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 vote230 views1 answer
Sql column contains special character
SQL
5 votes199 views1 answer
Oracle columns in all_tables
SQL
0 vote201 views1 answer
Create or replace view postgress
SQL
3 votes209 views1 answer
Locate sql server
SQL
0 vote220 views1 answer
PSQL use LIKE with timestamps
SQL
0 vote199 views1 answer
View psql output in horizontal scrolling
SQL
4 votes212 views4 answers
Rollback in sql
SQL
3 votes209 views1 answer
Postgresql db owner change
SQL
0 vote219 views1 answer
Sqlite3_open_v2
SQL
0 vote200 views1 answer
How to change the field size of an existing column
SQL