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 vote196 views2 answers
Mysql allow remote connections
SQL
0 vote194 views1 answer
Sqlalchemy query sql compiled
SQL
1 vote209 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL
0 vote223 views1 answer
How to define a non primary composite key in sql
SQL
12 votes220 views1 answer
Run mysql instance in docker
SQL
0 vote220 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote259 views1 answer
Sqlite trim
SQL
1 vote194 views1 answer
Can not connect to mysql server
SQL
0 vote272 views1 answer
Sql server remove primary key without dropping table
SQL
2 votes264 views2 answers
Mysql search for column name in all tables
SQL