Oracle find text in functions

SELECT * FROM all_source    -- or user_source or dba_source
WHERE upper(text) LIKE '%MY TEXT%'
	AND TYPE IN ('FUNCTION','PROCEDURE','PACKAGE')
ORDER BY owner, name, type, line;

Similar codes

1 vote314 views1 answer
Import database from a file using mysql commandline
SQL
0 vote393 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote311 views1 answer
Postgresql inline table
SQL
0 vote335 views1 answer
Mariadb cast null to 0
SQL
4 votes302 views1 answer
Oracle show error line number
SQL
9 votes340 views5 answers
Laravel to sql
SQL
0 vote340 views1 answer
Oracle sql number to varchar2
SQL
3 votes331 views3 answers
Start postgresql ubuntu
SQL
0 vote316 views1 answer
Number(10 2) in sql means
SQL
0 vote306 views1 answer
Fix sqlite3 ruby on rails
SQL