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 vote99 views1 answer
'0000-00-00' for column '
SQL
0 vote159 views1 answer
How to create notes in mysql
SQL
0 vote185 views1 answer
Sql to excel pgadmin
SQL
0 vote153 views1 answer
Mysql update privileges
SQL
5 votes141 views1 answer
How to get all dates in a month in oracle
SQL
0 vote158 views4 answers
Sql server date format yyyy-mm-dd
SQL
2 votes153 views1 answer
Express api ith mysql data
SQL
0 vote150 views1 answer
Stored function in sql
SQL
4 votes146 views1 answer
Mysql set max connections
SQL
0 vote142 views1 answer
C# add a textbox in mysql select
SQL