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 vote235 views1 answer
Sql padd let with zeros
SQL
50 votes264 views6 answers
Sql duplicate rows
SQL
0 vote241 views1 answer
Query to remove duplicate rows from a table
SQL
1 vote242 views1 answer
How to put value in variable mysql
SQL
0 vote262 views1 answer
Sql today at midnight
SQL
0 vote184 views1 answer
How to get last client id sql
SQL
3 votes249 views1 answer
Only join in sql
SQL
0 vote244 views1 answer
Oracle query archive mode
SQL
0 vote226 views1 answer
Create table if not exist with exceptions
SQL
1 vote249 views1 answer
Search for replace in mysql
SQL