Advanced Search

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