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

13 votes164 views2 answers
Check if value is null mysql
SQL
0 vote177 views1 answer
Insert array into mysql column
SQL
0 vote239 views1 answer
Liquibase update row
SQL
0 vote133 views1 answer
Print sum of values sql
SQL
1 vote176 views2 answers
How to enable error squiggles in vs code
SQL
0 vote179 views1 answer
Microsoft word insert sql code
SQL
0 vote178 views1 answer
T sql check active deadlock
SQL
3 votes166 views1 answer
Sql multiple column index
SQL
0 vote192 views1 answer
Show all sequences postgres
SQL
1 vote213 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL