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 vote132 views1 answer
Compare two tables to find unmatched records
SQL
0 vote125 views1 answer
Zerar auto increment mysql
SQL
0 vote138 views1 answer
Vs 2019 connect to local mysql database
SQL
0 vote136 views1 answer
Selecting duplicates
SQL
0 vote134 views1 answer
Sql drop procedure if exists
SQL
0 vote152 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
0 vote154 views1 answer
Show all sequences postgres
SQL
0 vote142 views1 answer
Create dump file mysql workbench
SQL
0 vote135 views1 answer
Sql server count all tables rows
SQL
1 vote186 views1 answer
Concat first name and last name in mysql
SQL