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

4 votes126 views4 answers
Rollback in sql
SQL
3 votes134 views1 answer
Postgresql cast
SQL
0 vote147 views1 answer
Implicit inner join table alias
SQL
0 vote155 views1 answer
Hallo
SQL
0 vote208 views1 answer
Mariadb date equals to current_date plus days
SQL
0 vote140 views1 answer
Utiliser sql ligne de commande
SQL
3 votes141 views2 answers
Sql random integer
SQL
1 vote111 views1 answer
Strict in postgres SQL
SQL
0 vote146 views1 answer
How to join result table in mysql
SQL
0 vote150 views2 answers
Port 5432 is already in use mac
SQL