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

0 vote120 views1 answer
Sql gap missing values
SQL
-1 vote82 views1 answer
Mysql how to set update or create
SQL
18 votes127 views4 answers
Uninstall mysql on ubuntu
SQL
0 vote119 views1 answer
View acl table oracle
SQL
0 vote140 views1 answer
Unique element in sql
SQL
3 votes127 views2 answers
Create schema postgres
SQL
0 vote143 views1 answer
Using distinct and count together in sql
SQL
0 vote184 views3 answers
How to find all role in mysql
SQL
0 vote130 views1 answer
Psql get table data types
SQL
0 vote159 views1 answer
Mysl like insert a variable
SQL