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

25 votes299 views5 answers
Date in mysql
SQL
46 votes339 views4 answers
Create column sql
SQL
0 vote274 views1 answer
The local psql command could not be located
SQL
58 votes569 views6 answers
Create new user in postgres
SQL
6 votes310 views3 answers
Mysql remove user privileges
SQL
0 vote285 views2 answers
Transaction php
SQL
0 vote274 views1 answer
Soql more than today
SQL
3 votes265 views1 answer
Sql several or
SQL
3 votes277 views3 answers
How to set up an auto incrementing id db browser
SQL
0 vote279 views1 answer
Find most frequent value in SQL column
SQL