/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 vote119 views1 answer
Add alternate add column sql
SQL
11 votes116 views1 answer
Mysql text type max length
SQL
0 vote126 views1 answer
New rails app with mysql
SQL
0 vote109 views2 answers
Mysql slave status
SQL
2 votes102 views2 answers
Mysql all columns
SQL
13 votes119 views4 answers
What is sql
SQL
5 votes124 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
0 vote114 views1 answer
Tsql generate rows
SQL
-1 vote116 views1 answer
Mysql select all columns and specific fields as
SQL
1 vote109 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL