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

3 votes172 views1 answer
Where id is in list sql
SQL
1 vote166 views1 answer
Psql human readable
SQL
1 vote204 views1 answer
Mysql sort by date column
SQL
1 vote153 views1 answer
What is in condition in sql
SQL
0 vote154 views1 answer
Tsql cmd exec script from file
SQL
0 vote160 views1 answer
Replace content value from old to new sql
SQL
1 vote342 views1 answer
Postgres upgrade to superuser
SQL
0 vote151 views1 answer
Why we have to set the password for my sql server
SQL
1 vote172 views1 answer
Mysql select for update ejemplo
SQL
0 vote155 views1 answer
Login failed for login due to trigger execution
SQL