Oracle search code in packages

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 vote192 views1 answer
Postgresql log
SQL
1 vote223 views1 answer
Oracle repeat_interval 5 minutes
SQL
7 votes206 views1 answer
Sql pagination oracle
SQL
0 vote193 views1 answer
Mysql range of dates overlap
SQL
5 votes199 views2 answers
Postgresql add not null constraint
SQL
2 votes187 views1 answer
How to make multiple keys as primary in bdms
SQL
0 vote186 views2 answers
Change database postgres
SQL
0 vote156 views1 answer
Sql table to store status
SQL
3 votes232 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
0 vote178 views7 answers
Les jointures sql server
SQL