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 vote191 views1 answer
Mysql_error replacement
SQL
0 vote185 views2 answers
Create row number in sql
SQL
0 vote185 views1 answer
Oracle current timestamp
SQL
1 vote197 views1 answer
Update from table tsql
SQL
0 vote200 views1 answer
Select distinct after join
SQL
5 votes184 views1 answer
Minecraft java port number
SQL
0 vote218 views1 answer
Add two days to current date in sql when creating tables
SQL
2 votes189 views2 answers
Get all tables using like
SQL
0 vote292 views1 answer
Wordpress sql find and replace
SQL
0 vote204 views1 answer
Como hacer una consulta en sql
SQL