/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

0 vote218 views2 answers
Drop check constraint in ms sql
SQL
0 vote226 views1 answer
How to add more columns to a table in mysql
SQL
0 vote224 views1 answer
Sub query in linq
SQL
0 vote244 views1 answer
Sparql if bound query
SQL
22 votes223 views4 answers
Show list of users in mysql
SQL
1 vote215 views1 answer
Display total number of tables in mysql
SQL
2 votes235 views3 answers
Sql function
SQL
1 vote228 views1 answer
Select count distinct multiple columns sql server
SQL
3 votes238 views1 answer
Oracle list user grants
SQL
9 votes242 views3 answers
Mysql run sql file
SQL