用SELECT TEXT FROM USER_VIEWS WHERE VIEW_NAME='TEST'只能出来一部分, 如: select A.a,A.b,B.c 后面的就没有了.
早上看到的时候,还不知道怎么回事,转了一圈以后知道了:[06.11]:如何获得创建视图的完整SQL?SQL> set long 1000000 SQL> select text from user_views where view_name='V';TEXT -------------------------------------------------------------------------- select rownum+(select min(t1) from t) - 1 as A from all_objects where rownum <= (select max(t1) - min(t1) + 1 from t)
如:
select A.a,A.b,B.c
后面的就没有了.
SQL> select text from user_views where view_name='V';TEXT
--------------------------------------------------------------------------
select rownum+(select min(t1) from t) - 1 as A from all_objects
where rownum <= (select max(t1) - min(t1) + 1 from t)