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

3 votes137 views1 answer
Oracle revoke grant
SQL
1 vote163 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
1 vote167 views1 answer
Psql search table
SQL
2 votes139 views1 answer
Anonymous block plsql
SQL
0 vote151 views1 answer
Drop view in mysql
SQL
0 vote156 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
1 vote139 views1 answer
Get rows affected mysql python
SQL
0 vote152 views2 answers
Postgresql variable in query
SQL
4 votes138 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
0 vote150 views1 answer
How to display value of variable in mysql
SQL