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

0 vote405 views1 answer
Mysl like insert a variable
SQL
0 vote332 views1 answer
Sqlite referential integrity
SQL
0 vote395 views1 answer
Fetching data from mysqldb
SQL
1 vote331 views1 answer
Oracle list constraints
SQL
8 votes351 views3 answers
Postgresql connection string c#
SQL
2 votes344 views1 answer
How to get weekday from old date in sql
SQL
0 vote343 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
0 vote417 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
0 vote387 views2 answers
Create-toys-table-with-toy_name-column
SQL
0 vote341 views1 answer
Postgress append string in select
SQL