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 vote130 views1 answer
Psql store procedure-return multiple table values
SQL
-1 vote79 views2 answers
Datetime sql server week
SQL
0 vote129 views1 answer
Mysql url
SQL
0 vote129 views1 answer
List column names of multiple tables psql
SQL
7 votes126 views4 answers
What is my mysql version
SQL
0 vote129 views1 answer
Alter precision
SQL
1 vote138 views2 answers
Mysql update table from another table
SQL
1 vote125 views1 answer
Spring postgresql reset auto increment to 0
SQL
1 vote123 views4 answers
Get week day from date in sql
SQL
1 vote144 views1 answer
How to see all table partition in oracle
SQL