Mostrar Objetos que hacen Referencia a un Objeto Especifico

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

Choose a language for easy browsing: