如何根据视图得到创建它所用到的表

Question

如题!!!!

Answer 1

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 createdSQL> 
SQL> create or replace view bookview as
  2    select *
  3      from book
  4  /View createdSQL> 
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                                                             TABLESQL>

Answer 2

补充楼上一下SELECT REFERENCED_NAME,REFERENCED_TYPE
FROM ALL_DEPENDENCIES
WHERE TYPE = 'VIEW'
AND OWNER='&OWNER'
AND NAME = '&NAME'
AND REFERENCED_TYPE = 'TABLE'
/

Answer 3

还需要进一步完善才好用：COL REFERENCED_OWNER FORMAT A15
COL REFERENCED_NAME FORMAT A15
SELECT REFERENCED_OWNER,REFERENCED_NAME,REFERENCED_TYPE
FROM ALL_DEPENDENCIES
WHERE TYPE = 'VIEW'
AND OWNER='&OWNER'
AND NAME = '&NAME'
AND REFERENCED_TYPE = 'TABLE'
/