Oracle find text in functions

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 vote113 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
3 votes110 views3 answers
Your password does not satisfy the current policy requirements
SQL
0 vote106 views1 answer
Mysql update sum same table
SQL
0 vote108 views1 answer
Mysql docker image for macbook m1
SQL
0 vote125 views1 answer
Postgresql cast as year and month from timestamp
SQL
0 vote108 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
44 votes220 views4 answers
Mysql alter table add column first
SQL
-1 vote136 views5 answers
Left join sql
SQL
13 votes113 views3 answers
Insert mysql ifile nto database
SQL
0 vote117 views1 answer
How to select an index in oracle sql
SQL