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 vote237 views1 answer
Convert LDAP Epoch to Date
SQL
0 vote251 views1 answer
Postgres change the name of schema
SQL
0 vote225 views1 answer
Call rest api from postgresql
SQL
22 votes237 views4 answers
Mysql date_format
SQL
0 vote239 views1 answer
Ubuntu stop mysql from starting on boot
SQL
2 votes227 views1 answer
Set column to not null mysql
SQL
0 vote221 views1 answer
Rabbitmq ui not working
SQL
0 vote230 views1 answer
Enable sql server full text indexing
SQL
0 vote230 views2 answers
Postgres default user
SQL
0 vote184 views1 answer
Oracle sql developer script output limit
SQL