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 vote217 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
0 vote234 views1 answer
Oracle decode
SQL
0 vote206 views1 answer
Netstat -tln mysql
SQL
0 vote186 views1 answer
Mysql calculated column
SQL
0 vote192 views1 answer
Mysql change default collation
SQL
2 votes199 views1 answer
How to insert string variable into sqlite database
SQL
0 vote267 views1 answer
Create dabase postgresql
SQL
0 vote209 views1 answer
Search db for table name
SQL
0 vote211 views1 answer
Postgresql create table with boolean column
SQL
0 vote234 views1 answer
Mysql limit order by
SQL