Oracle search code in 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 vote195 views1 answer
Postgres sequence name
SQL
1 vote177 views1 answer
Psql autocomplete for mac brew install
SQL
0 vote176 views1 answer
Partitioning in oracle-base
SQL
0 vote221 views1 answer
Postgresql on conflict pair
SQL
0 vote184 views1 answer
Get all employees if name ends with in sql
SQL
1 vote179 views1 answer
Mysql check if string contains comma separated
SQL
0 vote223 views1 answer
Virtuoso sql query tutorial
SQL
0 vote207 views2 answers
How to drop mili second in sql
SQL
7 votes202 views1 answer
Oracle reset sequence
SQL
17 votes180 views4 answers
Show tables sql server
SQL