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

4 votes180 views4 answers
Pl sql output
SQL
25 votes168 views6 answers
Import mysql database command line
SQL
7 votes163 views3 answers
How to check table name in current database sql
SQL
0 vote161 views1 answer
Downgrading sql localdb visual studio
SQL
1 vote161 views1 answer
Sql auto timestamp
SQL
0 vote169 views1 answer
Watch mysql command line
SQL
0 vote189 views1 answer
Openquery join two tables
SQL
0 vote175 views1 answer
Modifier une valeur sql
SQL
0 vote201 views1 answer
Mssql find deadlocks
SQL
0 vote189 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL