/ Published in: SQL
Mostrar Objetos que hacen Referencia a un Objeto Especifico en Oracle
Expand |
Embed | Plain Text
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;
You need to login to post a comment.
