select text from user_views where view_name = 'ABMBG_ACT_ACCT_DATA_VARIANCE';你要 设置一下可显示的长度
把视图名写在command窗口内,全选它单击右键选择view
SQL> create view demo as select * from tab;View created.SQL> select dbms_metadata.get_ddl('VIEW','DEMO') from dual;DBMS_METADATA.GET_DDL('VIEW','DEMO') -------------------------------------------------------------------------------- CREATE OR REPLACE FORCE VIEW "ME"."DEMO" ("TNAME", "TABTYPE", "CLUSTERID") AS SQL> set long 200 SQL> /DBMS_METADATA.GET_DDL('VIEW','DEMO') -------------------------------------------------------------------------------- CREATE OR REPLACE FORCE VIEW "ME"."DEMO" ("TNAME", "TABTYPE", "CLUSTERID") AS select "TNAME","TABTYPE","CLUSTERID" from tabSQL>
-------------------------------------------------------------------------------- CREATE OR REPLACE FORCE VIEW "ME"."DEMO" ("TNAME", "TABTYPE", "CLUSTERID") AS
SQL> set long 200
SQL> /DBMS_METADATA.GET_DDL('VIEW','DEMO')
-------------------------------------------------------------------------------- CREATE OR REPLACE FORCE VIEW "ME"."DEMO" ("TNAME", "TABTYPE", "CLUSTERID") AS
select "TNAME","TABTYPE","CLUSTERID" from tabSQL>