Oracle search code in 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 vote168 views1 answer
What is ssrs and ssis in sql server
SQL
0 vote155 views1 answer
How to execute stored output to csv files
SQL
3 votes172 views2 answers
Laravel tosql with bindings
SQL
0 vote123 views1 answer
Sqlalchemy filter relationship
SQL
0 vote187 views2 answers
Insert data mysql with cmd
SQL
7 votes171 views1 answer
Mysql iif
SQL
-2 votes231 views1 answer
Mysql not empty
SQL
18 votes165 views4 answers
Foreign key mySql
SQL
0 vote163 views1 answer
Mysql read row
SQL
7 votes168 views1 answer
Oracle pagination query offset
SQL