/ 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;