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 vote312 views1 answer
SQL query to verify the size of the table
SQL
0 vote298 views1 answer
VSCode SQL Server Connection error
SQL
0 vote317 views1 answer
Replace divide by zero error with 0 in sql
SQL
7 votes284 views1 answer
Postgres base size
SQL
10 votes300 views4 answers
How to alter table name in mysql
SQL
3 votes279 views1 answer
Show index table
SQL
0 vote312 views2 answers
Mysql where in maintain order group_concat
SQL
16 votes315 views1 answer
Mysql reset auto increment value
SQL
0 vote304 views1 answer
Second Step in installing SQL workbench
SQL
0 vote275 views1 answer
Mysql update sequence with order by
SQL