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

1 vote228 views3 answers
Update from select sqlite
SQL
1 vote216 views2 answers
Oracle replace
SQL
0 vote216 views1 answer
Postgres truncate with cascade
SQL
-1 vote255 views3 answers
MAKE TABLE FIT in oracle sql
SQL
1 vote208 views1 answer
Sql week commencing date
SQL
0 vote213 views1 answer
Mssql view column data type
SQL
2 votes230 views1 answer
How to delete all duplicate items in mysql
SQL
0 vote213 views1 answer
Phpmyadmin tabellentyp ändern
SQL
0 vote211 views1 answer
Sql count total by foreign key
SQL
2 votes204 views1 answer
Mysql sql add created updated timestamp to existing table
SQL