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

4 votes357 views2 answers
Postgre sql create table
SQL
0 vote355 views1 answer
Drop CHECK constraint sql
SQL
0 vote346 views1 answer
Postgresql import a database of gzip
SQL
0 vote374 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
0 vote370 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
7 votes359 views2 answers
What is sql clause
SQL
0 vote343 views1 answer
Install mysql 8 linux
SQL
1 vote352 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
0 vote351 views1 answer
Sqlplus change user
SQL
0 vote366 views1 answer
Oracle tablespace autoextend
SQL