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

0 vote148 views2 answers
Impala rename column name
SQL
0 vote421 views1 answer
How to connect .sql data set to powerbi
SQL
0 vote137 views1 answer
Delete duplicate rows
SQL
0 vote119 views1 answer
Postgresql heritage
SQL
1 vote135 views1 answer
Sql try catch
SQL
0 vote129 views1 answer
Find and replace query in wordpress\
SQL
2 votes129 views1 answer
Change primary key sql
SQL
0 vote95 views1 answer
Hangfire clean script
SQL
0 vote134 views1 answer
Oracle synonym procedure dblink
SQL
0 vote123 views1 answer
List all permissions on a table in postgres
SQL