Oracle: search though all saved procs / triggers / other db code?

Question

Is it possible to search all program objects (functions, stored procedures, triggers, etc.) by several schemes in Oracle?

There are several tables in my code that are not used in my code, but I do not want to break anything by deleting them without checking first.

Answer 1

You can search by object codes - usually you use the DBMS_METADATA package to generate DDL for the object, and then to search for the CLOB. However, this is not like what you want to do.

, - , DBA_DEPENDENCIES ( ALL_DEPENDENCIES USER_DEPENDENCIES , ). -

SELECT *
  FROM dba_dependencies
 WHERE referenced_owner = 'SCOTT'
   AND referenced_name  = 'EMP'
   AND referenced_type  = 'TABLE'

, EMP SCOTT.

, , DBA_DEPENDENCIES, , , SQL, . .

Answer 2

DBA_SOURCE:

SELECT *
  FROM dba_source
 WHERE UPPER(text) LIKE '%YOUR_TABLE_NAME%';

Answer 3

Toad, :

= >

Answer 4

Toad, . ( )