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

2 votes327 views1 answer
Oracle percentage
SQL
1 vote379 views1 answer
How not to sort by average rating
SQL
1 vote340 views1 answer
Sql server 2012 query history
SQL
6 votes337 views2 answers
What is non relational database
SQL
0 vote381 views1 answer
Sql alternative to max statement
SQL
8 votes340 views1 answer
Oracle add auto_increment column to existing table
SQL
0 vote338 views1 answer
Oracle tablespace autoextend
SQL
0 vote346 views1 answer
Rename constraint postgresql
SQL
1 vote352 views1 answer
Psql view enum values
SQL
2 votes380 views1 answer
Capitalize 1st letter in sql server
SQL