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

6 votes217 views3 answers
Mysql first day of year
SQL
1 vote225 views1 answer
Size of all tables in a schema oracle
SQL
1 vote233 views1 answer
Mysql select if empty result
SQL
0 vote240 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
1 vote239 views1 answer
Cross schema query oracle 2 users
SQL
5 votes237 views3 answers
Oracle first day of last year
SQL
0 vote249 views1 answer
How to join result table in mysql
SQL
0 vote228 views1 answer
Codigo crear tablas sql server
SQL
0 vote226 views1 answer
Postgres drop type
SQL
2 votes246 views1 answer
Pdo mysql insert
SQL