/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

2 votes206 views1 answer
How to delete all duplicate items in mysql
SQL
0 vote200 views1 answer
Least spark sql
SQL
15 votes204 views4 answers
Export mysql db using command line
SQL
11 votes197 views4 answers
MYSQL LOGIN
SQL
0 vote183 views1 answer
Create or replace view postgress
SQL
0 vote196 views1 answer
View to table sql
SQL
15 votes193 views1 answer
Mysql int range
SQL
16 votes176 views3 answers
Order by sql query
SQL
0 vote191 views1 answer
How to get initials in sql
SQL
0 vote177 views1 answer
Generate sequence number in sql server
SQL