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 vote297 views1 answer
Mysql create index lost connection
SQL
0 vote249 views1 answer
Install ms sql server management studio
SQL
0 vote244 views1 answer
Postgresql create table with boolean column
SQL
25 votes258 views6 answers
Sql update query
SQL
0 vote248 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
2 votes251 views2 answers
Change mysql password from command line
SQL
1 vote278 views3 answers
Reseed sql table primary key
SQL
49 votes295 views6 answers
Get duplicate records in sql
SQL
2 votes311 views1 answer
Remove foreign key constraints in postgres
SQL
-1 vote258 views1 answer
How to create foreign key in sql server management studio
SQL