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 vote177 views4 answers
Convert databse to achieve log mode oracle
SQL
5 votes187 views2 answers
Mysql dump mysql db cli
SQL
0 vote154 views1 answer
Traccar mysql
SQL
-1 vote142 views2 answers
On update cascade
SQL
1 vote155 views1 answer
Postgresql delete cascade
SQL
0 vote153 views1 answer
Mysql dump everythign
SQL
5 votes177 views1 answer
Oracle columns in all_tables
SQL
0 vote154 views1 answer
Linked server delete openquery
SQL
0 vote142 views1 answer
Table or view does not exist
SQL
0 vote158 views1 answer
Sqlite3 update select
SQL