Skip to content

Instantly share code, notes, and snippets.

@attibalazs

attibalazs/Oracle_get_all_dependencies.sql

Created February 21, 2017 15:21
Show Gist options
  • Save attibalazs/2ca4102de86319eb9b276d7ebe402877 to your computer and use it in GitHub Desktop.
Save attibalazs/2ca4102de86319eb9b276d7ebe402877 to your computer and use it in GitHub Desktop.
Download ZIP
Get all dependencies for oracle table or view. A hierarchical query which goes through the dependency tree.
Raw
Oracle_get_all_dependencies.sql
select distinct *
from all_dependencies a
start with a.referenced_name = 'TEST'
connect by NOCYCLE prior a.name = a.referenced_name;
@febzhang
Copy link

exactly what i needed, thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment