Posted By

thescorpion on 10/12/12

Tagged

sql
Oracle

Versions (?)

Last Edited at 10/12/12 02:59am

Statistics

Viewed 930 times

Favorited by 0 user(s)

Related snippets

Mostrar Objetos que hacen Referencia a un Objeto Especifico

/ Published in: SQL

Mostrar Objetos que hacen Referencia a un Objeto Especifico en Oracle

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

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;