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

3 votes285 views1 answer
Postgresql where current year
SQL
0 vote323 views1 answer
Groupby error in mysql
SQL
0 vote344 views1 answer
Last date for each user sql
SQL
0 vote353 views1 answer
ACCEPT nome PROMPT on oracle
SQL
1 vote312 views1 answer
Primary key reset in SQL database
SQL
4 votes346 views1 answer
Id increment ms sql server
SQL
1 vote333 views1 answer
Too many connections mysql
SQL
0 vote320 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
0 vote349 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote344 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL