Skip to content

Instantly share code, notes, and snippets.

@yujihamaguchi

yujihamaguchi/gist:a7c7aef21fc0eeb187f2

Created August 8, 2014 06:51
Show Gist options
  • Save yujihamaguchi/a7c7aef21fc0eeb187f2 to your computer and use it in GitHub Desktop.
Save yujihamaguchi/a7c7aef21fc0eeb187f2 to your computer and use it in GitHub Desktop.
Download ZIP
[Oracle] オブジェクトを指定し、そのオブジェクトに依存しているオブジェクトをリストする
Raw
gistfile1.sql
SELECT
owner
,name
,type
,referenced_link_name
,dependency_type
FROM
dba_dependencies
WHERE
referenced_owner = UPPER('&owner')
AND referenced_name = UPPER('&object_name')
/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment