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

0 vote116 views1 answer
Store query result in variable sql
SQL
1 vote143 views1 answer
Delete row mssql
SQL
3 votes152 views1 answer
Locate sql server
SQL
7 votes148 views2 answers
Html to react converter
SQL
1 vote200 views1 answer
Sql comment header
SQL
0 vote173 views1 answer
SQL joins in python
SQL
3 votes164 views1 answer
Where id is in list sql
SQL
0 vote137 views1 answer
Strat with in sql
SQL
3 votes171 views1 answer
What is having
SQL
1 vote109 views1 answer
Ms sql - add one hour to time
SQL