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

2 votes185 views2 answers
Set database timezone mysql
SQL
0 vote169 views2 answers
Get top 1 row of each group
SQL
0 vote176 views1 answer
Postgres read table structure
SQL
3 votes181 views1 answer
Stpop start psql server
SQL
0 vote182 views1 answer
Why we have to set the password for my sql server
SQL
2 votes221 views1 answer
Show max_allowed_packet mysql
SQL
0 vote192 views1 answer
Sparql list all graphs
SQL
-1 vote180 views1 answer
Pl/sql how to delete a trigger
SQL
5 votes245 views1 answer
Migrate sql table another database
SQL
49 votes257 views6 answers
Alter table add column
SQL