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

7 votes353 views3 answers
How to check table name in current database sql
SQL
0 vote376 views1 answer
Mysql search like but first exact match
SQL
3 votes368 views1 answer
Postgresql db owner change
SQL
4 votes362 views2 answers
Linq join
SQL
2 votes400 views1 answer
Mysql create user with remote access
SQL
0 vote392 views1 answer
For select oracle
SQL
0 vote350 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
1 vote359 views2 answers
Changes not showing on website server odoo
SQL
4 votes363 views2 answers
Mysql alter table set column unique
SQL
3 votes386 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL