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

-1 vote165 views4 answers
Postgres between dates
SQL
16 votes155 views3 answers
Get count of duplicate records
SQL
0 vote146 views1 answer
Sql value exists in column
SQL
0 vote179 views1 answer
Display all node label neo4j
SQL
10 votes142 views4 answers
Primary key sql
SQL
0 vote129 views1 answer
SQL Server format datetime
SQL
4 votes131 views2 answers
Postgres update single column
SQL
0 vote135 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
4 votes133 views1 answer
Id primary key auto generated
SQL
1 vote135 views1 answer
Mysql select row max date
SQL