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

7 votes246 views2 answers
What is sql clause
SQL
0 vote271 views1 answer
Pgadmin check database
SQL
0 vote242 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote250 views1 answer
Oracle lower in where clause
SQL
11 votes248 views2 answers
Insert date sql
SQL
2 votes238 views3 answers
Current month mysql query
SQL
1 vote242 views1 answer
Postgresql pass array in function
SQL
17 votes234 views3 answers
How to change a collumn name in sql
SQL
23 votes258 views4 answers
Uninstall postgresql ubuntu
SQL
4 votes270 views1 answer
Sql select limit range
SQL