オブジェクトの参照関係を調べる

構文

SELECT
    name,
    referenced_type,
    referenced_name
FROM
    user_dependencies
WHERE
    type = '<参照元オブジェクトの種類>'
AND
    referenced_name = '<参照先オブジェクトの名前>'

使用例一覧

col OWNER for a20
col NAME for a30
col REFERENCED_TYPE for a20
col REFERENCED_NAME for a30

--全オブジェクト確認
SELECT owner, name, referenced_type, referenced_name FROM dba_dependencies 
WHERE referenced_name = '<TARGET_OBJECT>';

--ビュー確認
SELECT owner, name, referenced_type, referenced_name FROM dba_dependencies 
WHERE type = 'VIEW' AND referenced_name = '<TARGET_OBJECT>';

--プロシージャ確認
SELECT owner, name, referenced_type, referenced_name FROM dba_dependencies 
WHERE type = 'PROCEDURE' AND referenced_name = '<TARGET_OBJECT>';

--ファンクション確認
SELECT owner, name, referenced_type, referenced_name FROM dba_dependencies 
WHERE type = 'FUNCTION' AND referenced_name = '<TARGET_OBJECT>';

--パッケージ確認
SELECT owner, name, referenced_type, referenced_name FROM dba_dependencies 
WHERE type = 'PACKAGE' AND referenced_name = '<TARGET_OBJECT>';

--パッケージボディ確認
SELECT owner, name, referenced_type, referenced_name FROM dba_dependencies 
WHERE type = 'PACKAGEBODY' AND referenced_name = '<TARGET_OBJECT>';

--トリガー確認
SELECT owner, name, referenced_type, referenced_name FROM dba_dependencies 
WHERE type = 'TRIGGER' AND referenced_name = '<TARGET_OBJECT>';

参考サイト：備忘録（ビューを調査する）
URL：http://bag-end.hatenablog.com/entry/2014/01/02/110552

dependencies・・・依存関係という意味