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 vote134 views1 answer
Convert rows to columns in sql server
SQL
45 votes220 views5 answers
Grant all privileges mysql
SQL
0 vote138 views1 answer
Rabbitmq service not starting
SQL
2 votes139 views1 answer
Oracle apex list connected users
SQL
19 votes145 views6 answers
Sql server drop table if exists
SQL
0 vote138 views1 answer
Sqlite select split string
SQL
0 vote155 views1 answer
Original Query
SQL
0 vote146 views2 answers
Connect to mysql server mac terminal
SQL
7 votes142 views4 answers
How to reset the identity column in sql server
SQL
2 votes148 views1 answer
Oracle convert run_duration to number
SQL