/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 vote182 views1 answer
<sql:datasource var="Snapsho"
SQL
0 vote125 views1 answer
Oracle table free space
SQL
0 vote163 views1 answer
Sqlalchemy orm duplicate
SQL
0 vote127 views1 answer
Ms sql filter all sympbol
SQL
13 votes106 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote153 views1 answer
Ms sql print more than 1 variable
SQL
0 vote117 views1 answer
Denormalise SQL command
SQL
0 vote116 views1 answer
Mysql where in keep order
SQL
0 vote124 views1 answer
Oracle procedure teamplate
SQL
1 vote110 views1 answer
Sql auto date
SQL