Oracle all_source package body

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

17 votes201 views5 answers
Order by sql
SQL
-1 vote168 views1 answer
Extract Data from SQL Server into XML Format
SQL
0 vote177 views1 answer
Docker export psql sql
SQL
1 vote182 views1 answer
Mysql alter decimal precision
SQL
3 votes239 views1 answer
Query less than datetime sql
SQL
16 votes210 views1 answer
Mysql smallint range
SQL
0 vote242 views1 answer
Mssql describe stored procedure sqlcmd
SQL
0 vote198 views1 answer
USING THE NOT CONDITION IN SQL
SQL
3 votes186 views1 answer
Sql replace character in string in all records
SQL
0 vote203 views1 answer
Call function in query sql server
SQL