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 vote180 views1 answer
Add week ending date sql server
SQL
1 vote141 views1 answer
Snowflake rename column name
SQL
0 vote127 views1 answer
Min and max salary and name in sql
SQL
5 votes153 views3 answers
Show indexes mysql
SQL
0 vote139 views1 answer
Changing name of column and datatype in sql
SQL
0 vote138 views1 answer
Mysqldump don't drop table
SQL
2 votes147 views1 answer
Postgresql transaction
SQL
2 votes120 views1 answer
Oracle sql concatenate results into string
SQL
2 votes143 views2 answers
Postgres timestamp to datetime
SQL
11 votes146 views3 answers
Sql line numbers
SQL