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 vote203 views1 answer
Oracle index hint multiple tables example
SQL
8 votes218 views2 answers
Alert table name mysql
SQL
0 vote204 views2 answers
Azure sql-datenbank
SQL
10 votes220 views2 answers
Rtrim sql
SQL
11 votes219 views3 answers
Change column name sql server management studio
SQL
0 vote190 views1 answer
'0000-00-00' for column '
SQL
6 votes209 views1 answer
How to count number of rows in sql
SQL
-1 vote241 views2 answers
Installing mysql on centos 7
SQL
2 votes212 views1 answer
Oracle sql concatenate results into string
SQL
0 vote212 views1 answer
USING THE NOT CONDITION IN SQL
SQL