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

1 vote136 views1 answer
Get current date in pyspark sql
SQL
7 votes112 views3 answers
Postgresql dump and restore db
SQL
0 vote114 views1 answer
Search db for table name
SQL
16 votes123 views3 answers
Update table from another table
SQL
11 votes120 views3 answers
Python sqlite3 create table if not exists
SQL
0 vote123 views1 answer
Mysql type for large numbers with many decimal
SQL
4 votes137 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
11 votes122 views2 answers
MySQL DISTINCT
SQL
1 vote124 views1 answer
Oracle previous year
SQL
0 vote111 views1 answer
Delete double on SQL with multiple primary keys
SQL