Mostrar Objetos que hacen Referencia a un Objeto Especifico


/ Published in: SQL
Save to your folder(s)

Mostrar Objetos que hacen Referencia a un Objeto Especifico en Oracle


Copy this code and paste it in your HTML
  1. SELECT OWNER,
  2. TYPE,
  3. Name,
  4. REFERENCED_OWNER,
  5. REFERENCED_TYPE,
  6. REFERENCED_NAME
  7. FROM DBA_DEPENDENCIES
  8. WHERE ((OWNER LIKE UPPER('&1') AND Name LIKE UPPER('&2')) OR
  9. (REFERENCED_OWNER LIKE UPPER('&1') AND
  10. REFERENCED_NAME LIKE UPPER('&2')))
  11. AND REFERENCED_OWNER != 'SYS'
  12. AND REFERENCED_TYPE != 'NON-EXISTENT'
  13. ORDER BY OWNER, TYPE, Name;

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.