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

9 votes214 views6 answers
Sql insert into
SQL
1 vote234 views1 answer
Join to find results not in another table
SQL
11 votes195 views1 answer
Mysql text type max length
SQL
1 vote185 views1 answer
Mysql datetime with timezone offset
SQL
0 vote225 views1 answer
Allow null in psql
SQL
0 vote202 views1 answer
Databricks install odbc driver connect to sql server
SQL
0 vote203 views1 answer
How to check replication lag in mySQL
SQL
0 vote192 views1 answer
How to export table data from mysql table in sql format
SQL
1 vote202 views2 answers
Test sqlsrv connection
SQL
1 vote216 views1 answer
Oracle insert multiple rows into same table
SQL