/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

4 votes185 views2 answers
Mysql delete user if exists
SQL
0 vote219 views1 answer
Redshift running queries
SQL
4 votes167 views2 answers
REST API
SQL
0 vote166 views1 answer
How to use group_concat in sql server
SQL
0 vote188 views1 answer
Query for backup a database at another location in file system
SQL
1 vote191 views1 answer
Cannot drop database because it is currently in use
SQL
0 vote165 views1 answer
Sql menampilkan data tabel
SQL
29 votes174 views5 answers
Mysql show table structure
SQL
38 votes194 views6 answers
Ubuntu install mysql client
SQL
0 vote180 views1 answer
Sql declare variable single line
SQL