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

1 vote120 views1 answer
Input in mysql
SQL
0 vote113 views4 answers
Best data type to represent money in mysql
SQL
2 votes135 views3 answers
Application.properties spring boot mysql
SQL
0 vote120 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
1 vote128 views1 answer
Tsql replace value in json
SQL
4 votes108 views2 answers
Postgresql reset sequence
SQL
1 vote110 views2 answers
Mysql order by date asc null last
SQL
15 votes142 views4 answers
Mysql export database command line
SQL
9 votes118 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote138 views1 answer
What is default mysql database password in linux
SQL