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

1 vote217 views2 answers
Sql split string by space
SQL
0 vote161 views1 answer
Gcloud check sql
SQL
0 vote200 views1 answer
Mssql find deadlocks
SQL
0 vote170 views1 answer
Linebreak sql
SQL
0 vote184 views1 answer
Postgres copy command
SQL
0 vote273 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
6 votes164 views2 answers
Mysql set primary key
SQL
0 vote186 views1 answer
How convert into in in sql query
SQL
0 vote224 views1 answer
Postgres dump sql insert
SQL
0 vote170 views1 answer
Mysql master slave setup with keepalived
SQL