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

4 votes282 views1 answer
Wilayah indonesia sql
SQL
1 vote295 views1 answer
Oracle sql create view
SQL
-1 vote294 views1 answer
Search all database tables for a value sqlserver
SQL
-2 votes316 views1 answer
How-to-remove-mysql-root-password
SQL
0 vote315 views1 answer
Spark sql grows beyond 64 kb
SQL
2 votes281 views1 answer
Oracle log files
SQL
1 vote302 views1 answer
Error code 1292 mysql workbench
SQL
0 vote293 views1 answer
Select last N rows mysql
SQL
1 vote290 views1 answer
Declare variables sql
SQL
0 vote283 views1 answer
Jooq replace
SQL