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 vote209 views1 answer
Oracle case
SQL
0 vote204 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
0 vote197 views1 answer
Nth max in my sql
SQL
0 vote212 views1 answer
Oracle list partitions
SQL
2 votes214 views1 answer
Guid to string sql
SQL
6 votes314 views3 answers
POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
SQL
2 votes204 views2 answers
Enable foreign key checks postgres
SQL
0 vote186 views1 answer
Metada in sql
SQL
8 votes252 views2 answers
Default sql server port
SQL
0 vote225 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL