/SQL/Oracle search stored procedures for text

Oracle search stored procedures for text

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 vote133 views1 answer
Mysql show table character set
SQL
12 votes134 views4 answers
How to take database dump in postgresql
SQL
0 vote117 views1 answer
Ms sql unique
SQL
0 vote141 views1 answer
List all functions and procedures in postgres query
SQL
0 vote130 views1 answer
Get number of rows in every table mysql
SQL
0 vote137 views1 answer
How should I pass a table name into a stored proc?
SQL
11 votes144 views4 answers
Update row in mysql
SQL
0 vote134 views1 answer
Delete insert record in sql server
SQL
0 vote141 views1 answer
Restore backup mysql .gz
SQL
2 votes133 views1 answer
Oracle find constraints referencing a table
SQL