oracle中获取视图引用的表

1.创建测试表：book

SQL> create table BOOK
  2  (
  3    ID       NUMBER not null,
  4    IP       VARCHAR2(20),
  5    NAME     VARCHAR2(10),
  6    EMAIL    VARCHAR2(40),
  7    QQ       VARCHAR2(10),
  8    POSTTIME DATE
  9  )
 10  /

Table created

2.创建视图：bookview

SQL> create or replace view bookview as
  2    select *
  3      from book
  4  /

View created

3.获取视图引用的表：

SQL> SELECT REFERENCED_NAME, REFERENCED_TYPE
  2    FROM SYS.ALL_DEPENDENCIES
  3   WHERE TYPE = 'VIEW'
  4     AND NAME = UPPER('bookview')
  5     AND REFERENCED_TYPE = 'TABLE'
  6  /

REFERENCED_NAME                                                  REFERENCED_TYPE
---------------------------------------------------------------- -----------------
BOOK                                                             TABLE

SQL>