/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

3 votes157 views3 answers
Sql current year
SQL
3 votes125 views1 answer
Oracle user quota unlimited
SQL
0 vote138 views1 answer
How to query all tables mysql at the same time
SQL
0 vote134 views1 answer
T sql less than date
SQL
9 votes125 views1 answer
Mysql check date range
SQL
0 vote158 views1 answer
Split first name and last name in sql
SQL
0 vote135 views1 answer
Bidirectional outer join sql
SQL
0 vote144 views1 answer
How to get nth number in sql
SQL
0 vote137 views1 answer
Oracle shrink table
SQL
5 votes156 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL