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 vote98 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
3 votes126 views1 answer
Define REGEXP?
SQL
-1 vote106 views5 answers
Online sql to linq generator
SQL
0 vote106 views1 answer
To change the database owner in SQL server
SQL
0 vote103 views1 answer
Sql server count all tables rows
SQL
0 vote102 views1 answer
Add created and updatedAt fields in mysql
SQL
0 vote109 views1 answer
Disableforiegn key check
SQL
0 vote121 views1 answer
Hashpass
SQL
1 vote111 views1 answer
Tsql find foreign key references
SQL
1 vote109 views2 answers
Reset mysqli fetch_arra
SQL