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

20 votes142 views5 answers
Mysql reset auto increment to 1
SQL
1 vote139 views1 answer
Oracle avg
SQL
1 vote134 views1 answer
Set all the vluses in calumn in sql to false
SQL
0 vote82 views1 answer
FindAllBy
SQL
0 vote136 views2 answers
Mysql create table if not exists
SQL
3 votes135 views1 answer
Postgres update column with value from another table
SQL
0 vote147 views1 answer
Mysql pad zeros
SQL
0 vote105 views1 answer
Mysql collation for all languages
SQL
0 vote149 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
0 vote145 views1 answer
Grant access on table in oracle
SQL