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 vote151 views1 answer
Postgres full text search example
SQL
0 vote117 views1 answer
R2dbc-postgresqldriver dependency
SQL
9 votes133 views3 answers
Mysql run sql file
SQL
0 vote180 views1 answer
Postgres dump sql insert
SQL
0 vote133 views1 answer
Heidisql check how much space a row
SQL
0 vote122 views1 answer
Restore backup "text" postgresql command line
SQL
0 vote94 views1 answer
Expose db in virtualbox
SQL
1 vote121 views1 answer
Oracle aleter trigger ora-01031
SQL
7 votes132 views2 answers
Html to react converter
SQL
2 votes136 views2 answers
Insert all in sql
SQL