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

2 votes209 views2 answers
How to run postgresql in linux
SQL
0 vote197 views1 answer
Mysql table variables
SQL
3 votes186 views1 answer
What is having clause
SQL
0 vote207 views1 answer
Groupby sort sql hive
SQL
0 vote221 views1 answer
Oracle list datafiles
SQL
2 votes189 views1 answer
Sql alchemy or
SQL
3 votes235 views1 answer
Unsigned int in mysql
SQL
0 vote240 views1 answer
Oracle show running job
SQL
7 votes194 views3 answers
Sql update where id
SQL
3 votes204 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL