视图是以select语句存储于oracle中,可以查询xxx_views
SQL> select text from user_views where view_name='V_EMP';
TEXT
--------------------------------------------------------------------------------
select "EMPNO","ENAME","JOB","MGR","HIREDATE","SAL","COMM","DEPTNO" from scott.e
mp
阅读(692) | 评论(0) | 转发(0) |