Oracle search text in all 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 vote389 views1 answer
Check if record exists mysql
SQL
0 vote386 views3 answers
Condition in count sql
SQL
7 votes338 views1 answer
Oracle set sequence value to max(id)
SQL
3 votes450 views4 answers
Sql interview questions
SQL
2 votes426 views2 answers
MySql FULL OUTER JOIN
SQL
0 vote339 views1 answer
Save single sql query result boolean spring boot
SQL
0 vote344 views2 answers
Sqlite
SQL
8 votes377 views1 answer
Script to add datafile to tablespace
SQL
0 vote382 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
0 vote429 views1 answer
Dockerfile example for Django
SQL