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

11 votes348 views4 answers
Query DISTINCT
SQL
0 vote353 views2 answers
Reseed sql identity
SQL
1 vote335 views1 answer
Sql oracle update multiple rows
SQL
3 votes330 views2 answers
Oracle for loop
SQL
0 vote364 views2 answers
Postgres show current role
SQL
0 vote373 views1 answer
Sql query contains multiple ids
SQL
0 vote298 views1 answer
Oracle sql developer script output limit
SQL
0 vote391 views1 answer
Date 3 months from today sql
SQL
13 votes341 views4 answers
Mysql select last 10 rows
SQL
0 vote424 views1 answer
Mysql dump for selected row
SQL