Oracle search text in all packages

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 vote200 views1 answer
Mysql get nth highest
SQL
0 vote192 views1 answer
T sql check active deadlock
SQL
0 vote186 views1 answer
Sql recherche nom prenom
SQL
0 vote166 views2 answers
Influxdb delete measurement based on date
SQL
0 vote187 views1 answer
Mysql milliseconds
SQL
3 votes196 views1 answer
Force using index plsql
SQL
2 votes184 views1 answer
Find all triggers in database
SQL
38 votes265 views4 answers
Count sql
SQL
0 vote195 views1 answer
How to install Firebird
SQL
0 vote214 views1 answer
Mysql preg replace
SQL