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 vote321 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
0 vote364 views1 answer
Selecting duplicates
SQL
7 votes345 views1 answer
Alter sequence set current value oracle
SQL
0 vote334 views1 answer
Sql drop default
SQL
0 vote356 views1 answer
Set Mamp mysql globally
SQL
1 vote324 views1 answer
Postgresql filter on
SQL
5 votes355 views2 answers
Oracle find all tables with column name
SQL
1 vote336 views1 answer
Pl sql ptint
SQL
0 vote308 views1 answer
Mysql sleep connections
SQL
2 votes312 views3 answers
Application.properties spring boot mysql
SQL