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

22 votes272 views6 answers
Create sql table
SQL
4 votes244 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
0 vote308 views1 answer
Show mysql account privilleges
SQL
5 votes294 views1 answer
Commentaire table oracle
SQL
0 vote268 views2 answers
Which MySQL statement is used to delete data from a database
SQL
1 vote296 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
0 vote280 views1 answer
EnvironmentError: mysql_config not found
SQL
0 vote293 views1 answer
How to get parent and child record in single query using sql
SQL
1 vote287 views1 answer
Wordpress change url phpmyadmin
SQL
0 vote284 views1 answer
Postgresql not in alternative
SQL