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 vote185 views1 answer
Sql server information_schema temp tables
SQL
0 vote157 views2 answers
Which MySQL statement is used to delete data from a database
SQL
0 vote163 views1 answer
Oracle change password expiration policy
SQL
0 vote142 views1 answer
SQL server select to get sum of hours
SQL
1 vote151 views1 answer
Check message id sql server
SQL
2 votes168 views2 answers
Storing timezones in postgres
SQL
0 vote207 views1 answer
Tsql find procedure with name
SQL
0 vote161 views1 answer
Mysql join column order By and group By
SQL
0 vote148 views1 answer
Oracle last connection
SQL
0 vote151 views1 answer
Calculate age in sql
SQL