/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

3 votes366 views1 answer
Force using index plsql
SQL
0 vote371 views1 answer
How to to get time in sql
SQL
0 vote358 views1 answer
User defined variables in sql
SQL
5 votes356 views2 answers
Add column postgres with default value
SQL
0 vote408 views2 answers
How to install psql in ubuntu
SQL
18 votes364 views3 answers
Mysql query add column with default string value
SQL
-1 vote342 views1 answer
Export mysql table to file
SQL
1 vote341 views1 answer
Sql oracle update multiple rows
SQL
0 vote442 views1 answer
Mysql show schema
SQL
1 vote396 views1 answer
Sqlalchemy order by descending
SQL