user_dependencies_trigger_view_package_body依賴

SQL> create view v_e_teacherloginfo as select * from e_teacherlogininfo;

View created.

SQL> select name,type,referenced_owner,referenced_name,dependency_type from user_dependencies;

NAME                                               TYPE                 REFERENCED_OWNER               REFERENCED_NAME                DEPE
-------------------------------------------------- -------------------- ------------------------------ ------------------------------ ----
PKG_E_TEACHERLOGININFO                             PACKAGE BODY         SYS                            STANDARD                       HARD
PKG_E_TEACHERLOGININFO                             PACKAGE              SYS                            STANDARD                       HARD
V_E_TEACHERLOGINFO                                 VIEW                 PD                             E_TEACHERLOGININFO             HARD
PKG_E_TEACHERLOGININFO                             PACKAGE BODY         PD                             PKG_E_TEACHERLOGININFO         HARD