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

5 votes266 views1 answer
Add column table sql default value
SQL
1 vote236 views2 answers
Laravel get sql query eloquent with parameters
SQL
1 vote225 views1 answer
Jooq convert using gbk
SQL
0 vote209 views1 answer
Automate mysql cli query
SQL
0 vote229 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
1 vote230 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
0 vote223 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
1 vote221 views1 answer
How to select department from table
SQL
0 vote236 views1 answer
Change magento database url usimg musql
SQL
0 vote227 views1 answer
Which MySQL data type to use for storing boolean values
SQL