显示procedures, packages, functions, package bodies, and triggers 和 基于非dblink的视图 的 依赖性。
DBA_DEPENDENCIES describes all dependencies in the database between procedures, packages, functions, package bodies, and triggers, including dependencies on views created without any database links. Its columns are the same as those in "ALL_DEPENDENCIES".

举例：

create view GDBMZD
as
SELECT KCBMZD_BMBH AS GDBMZD_BMBH , KCBMZD_BMMC AS GDBMZD_BMMC,
KCBMZD_JS AS GDBMZD_JS, KCBMZD_MX AS GDBMZD_MX,KCBMZD_DH AS GDBMZD_NOTE
FROM KCBMZD
/

然后去DBA_DEPENDENCIES查询，如下的结果：


[@more@]