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>
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>