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 vote319 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
25 votes319 views1 answer
Mysql grant all privileges to a user
SQL
0 vote309 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
38 votes320 views4 answers
Count sql
SQL
0 vote349 views2 answers
Insert data mysql with cmd
SQL
1 vote325 views4 answers
Aggregate function in sql
SQL
4 votes299 views1 answer
Postgresql show current database
SQL
1 vote319 views1 answer
PL SQL MODIFY COLUMN NME
SQL
1 vote320 views1 answer
Drush sql-dump
SQL
17 votes306 views4 answers
Set mysql Password
SQL