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

17 votes183 views2 answers
How to assign date field for table in mysql
SQL
1 vote231 views1 answer
Mysql view curren querys
SQL
2 votes222 views1 answer
How to select from mssql
SQL
3 votes197 views2 answers
Postgresql select all column names
SQL
2 votes200 views1 answer
Mysql set value as null
SQL
0 vote156 views1 answer
Oracle sql developer script output limit
SQL
0 vote212 views1 answer
Oracle drop type
SQL
16 votes243 views1 answer
Mysql mediumint max value
SQL
1 vote200 views3 answers
Union in sql
SQL
0 vote205 views1 answer
Wordpress database query change url
SQL