Oracle all_source package body

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

13 votes220 views1 answer
Sql join 3 tables on id
SQL
1 vote205 views3 answers
Rename table snowflake
SQL
24 votes227 views4 answers
Mysql datetime
SQL
0 vote231 views1 answer
Mysql extract day from date leading zero
SQL
1 vote230 views2 answers
Get table column names sql laravel
SQL
0 vote228 views1 answer
Sql join on a subquery
SQL
0 vote197 views1 answer
What are the aggregate function in sql
SQL
0 vote162 views1 answer
Mitigation of sql injection
SQL
0 vote217 views1 answer
Linked server delete openquery
SQL
7 votes207 views1 answer
Oracle reset sequence
SQL