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 vote155 views1 answer
Sql min
SQL
0 vote156 views1 answer
Hoq to import database source
SQL
9 votes163 views2 answers
Convert data type in sql
SQL
1 vote164 views1 answer
How to put value in variable mysql
SQL
1 vote140 views1 answer
Check constraint to check if date greater than todays date
SQL
1 vote154 views1 answer
Postgresql how to show table names
SQL
-1 vote139 views2 answers
How to display top 50 rows?
SQL
0 vote146 views1 answer
Split string by comma in sql server
SQL
3 votes151 views1 answer
Oracle apex warning message
SQL
0 vote186 views1 answer
Mysql loop through databases and execute query
SQL