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

0 vote246 views1 answer
Select only one row sql
SQL
0 vote264 views1 answer
Mysql calculated column
SQL
1 vote281 views1 answer
Postgres see sequence current state
SQL
0 vote279 views2 answers
Compound operator in sql
SQL
0 vote301 views3 answers
How to find all role in mysql
SQL
1 vote229 views1 answer
Psql show with user is logged in
SQL
7 votes259 views1 answer
Sql server management studio turn on line numbers
SQL
1 vote254 views1 answer
Order by oracle
SQL
-1 vote256 views1 answer
Partial search in sql
SQL
1 vote250 views1 answer
Psql connect to another database
SQL