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

0 vote255 views1 answer
Sqlite update where exists
SQL
24 votes283 views4 answers
Postgres delete database
SQL
0 vote267 views1 answer
Change permission to database mysql
SQL
0 vote253 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote281 views1 answer
Sql column contains special character
SQL
0 vote276 views1 answer
Sqlite insert or update
SQL
1 vote263 views2 answers
Oracle difference between two dates in seconds
SQL
0 vote247 views1 answer
C# select Mysql
SQL
0 vote240 views1 answer
How to find top 3 salary in sql
SQL
1 vote214 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL