Return to Snippet

Revision: 59956
at October 12, 2012 02:59 by thescorpion


Initial Code
Select OWNER,
       Type,
       Name,
       REFERENCED_OWNER,
       REFERENCED_TYPE,
       REFERENCED_NAME
  From DBA_DEPENDENCIES
 Where ((OWNER Like UPPER('&1') And Name Like UPPER('&2')) Or
       (REFERENCED_OWNER Like UPPER('&1') And
       REFERENCED_NAME Like UPPER('&2')))
   And REFERENCED_OWNER != 'SYS'
   And REFERENCED_TYPE != 'NON-EXISTENT'
 Order By OWNER, Type, Name;

Initial URL

                                

Initial Description
Mostrar Objetos que hacen Referencia a un Objeto Especifico en Oracle

Initial Title
Mostrar Objetos que hacen Referencia a un Objeto Especifico

Initial Tags
sql, Oracle

Initial Language
SQL