Oracle search text in all 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

3 votes173 views2 answers
MySQL query to get column names
SQL
2 votes159 views1 answer
Pdo mysql insert
SQL
0 vote136 views1 answer
Trim sql oracle
SQL
0 vote153 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
0 vote151 views1 answer
Dump only data
SQL
0 vote166 views1 answer
Create view in sql server that contain multiple select statements
SQL
0 vote154 views1 answer
Rename constraint postgresql
SQL
3 votes154 views4 answers
Show databases in sql server
SQL
31 votes171 views2 answers
Grant all priviledges to mysql user
SQL
0 vote156 views1 answer
Python mysqlclient library not found for -lssl
SQL