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 vote276 views1 answer
Example of sql querry result sepapreted by comma
SQL
0 vote186 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
0 vote280 views1 answer
MySQL - How to find word with the most similar beginning
SQL
0 vote228 views1 answer
Hashpass
SQL
-1 vote211 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
1 vote213 views2 answers
Setval max id postgresql sequence
SQL
0 vote212 views1 answer
List mysql tables and views
SQL
0 vote259 views2 answers
Sql unique
SQL
0 vote194 views1 answer
How to count with except in psql
SQL
0 vote213 views1 answer
Query only first letter string
SQL