/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 vote179 views1 answer
Sql server bool select
SQL
0 vote287 views1 answer
Mysql collation portugues brasil
SQL
0 vote189 views1 answer
Mysql does collate nopad recognize space
SQL
22 votes188 views4 answers
Mysql reset auto increment id
SQL
1 vote609 views1 answer
How to lock table in mysql
SQL
0 vote189 views1 answer
Sql select with apostrohpe
SQL
3 votes222 views1 answer
Oracle cannot access v$session
SQL
0 vote227 views1 answer
Como hacer un select entre fechas mysql
SQL
11 votes199 views1 answer
Sql query to find duplicates in column
SQL
0 vote192 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL