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 vote266 views1 answer
Psql initialization
SQL
0 vote242 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
3 votes227 views1 answer
Oracle list invalid password ORA-01017
SQL
0 vote232 views1 answer
Mysql utc timestamp
SQL
0 vote256 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
1 vote244 views1 answer
Table information in sql server
SQL
4 votes190 views1 answer
Oracle sleep
SQL
0 vote235 views1 answer
Mysql sql select one day before
SQL
0 vote244 views1 answer
Mysql terminal run sql file
SQL
5 votes266 views2 answers
Add days in oracle sql
SQL