/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 vote190 views2 answers
Oracle list service names
SQL
16 votes189 views4 answers
Mysql import from sql file
SQL
0 vote179 views1 answer
Oracle list proxy users
SQL
16 votes180 views6 answers
Mysql find and replace
SQL
4 votes171 views2 answers
Sql select except null
SQL
24 votes179 views5 answers
Sql server insert into select
SQL
0 vote207 views1 answer
Calculer pourcentage mysql
SQL
13 votes215 views3 answers
Mysqldump structure only
SQL
5 votes187 views4 answers
Rollback to in sql
SQL
2 votes187 views1 answer
How to find table table in stored procedure sql server
SQL