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 vote117 views1 answer
Window function to forward fill
SQL
0 vote104 views1 answer
Mysql DDL
SQL
2 votes69 views1 answer
Oracle current date without time
SQL
0 vote109 views1 answer
Sql delete from with relation
SQL
13 votes106 views2 answers
Get date from now() mysql
SQL
1 vote97 views1 answer
How refresh navicat tables to see new tables
SQL
0 vote238 views1 answer
Generate a random otp in sql server
SQL
7 votes108 views3 answers
Postgresql dump and restore db
SQL
11 votes119 views2 answers
How to import mysql database command line
SQL
1 vote101 views1 answer
Oracle explain plan
SQL