select * from dba_views where view_name = 'yourviewname';
SQL> col REFERENCED_NAME format a30; SQL> select NAME, REFERENCED_NAME from user_dependencies where name = 'V_T1' and REFERENCED_TYPE='TABLE';NAME REFERENCED_NAME ------------------------------ ------------------------------ V_T1 T1
假若你的视图名字为MYVIEW,则SELECT TEXT FROM USER_VIEWS WHERE VIEW_NAME='MYVIEW';
SQL> select NAME, REFERENCED_NAME from user_dependencies where name = 'V_T1' and
REFERENCED_TYPE='TABLE';NAME REFERENCED_NAME
------------------------------ ------------------------------
V_T1 T1
FROM USER_VIEWS
WHERE VIEW_NAME='MYVIEW';
type='VIEW'
注意要大写