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 vote114 views1 answer
Select lowest values sql
SQL
5 votes120 views6 answers
In operator sql
SQL
0 vote147 views2 answers
Mysql cast to varchar
SQL
11 votes108 views1 answer
How to get ddl for materialized view
SQL
0 vote94 views1 answer
Update having mysql
SQL
12 votes102 views5 answers
Sql primary key
SQL
4 votes111 views2 answers
Postgre sql create table
SQL
0 vote98 views1 answer
Commit transaction sql
SQL
4 votes108 views1 answer
Mysql ip address data type
SQL
0 vote118 views1 answer
Mysql regex select
SQL