SQL> SET LONG 480000; SQL> select dbms_metadata.get_ddl('TABLE','T1') from dual;DBMS_METADATA.GET_DDL('TABLE', -------------------------------------------------------------------------------- CREATE TABLE "SYS"."T1" ( "(asdada!!@#!)" NVARCHAR2(30) ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" SQL> 把TABLE换成vIEW,T1换成你的vIEW名称
select dbms_metadata.get_ddl('TABLE','TEST') from dual; ---TEST改为你的查的VIEW名字
select dbms_metadata.get_ddl('VIEW','TEST') from dual;
Above method or following 2nd way: SQL> SET LONG 10000; SQL> SELECT TEXT 2 FROM ALL_VIEWS 3 WHERE OWNER = UPPER('DSS_DEV') 4 AND VIEW_NAME = UPPER('ALVW_AL_USAGE');TEXT -------------------------------------------------------------------------------- ( select PARENT_OBJ,PARENT_OBJ_TYPE from AL_USAGE union select DESCEN_OBJ,DESCEN_OBJ_TYPE from AL_USAGE ) SQL>
SQL> SET LONG 480000;
SQL> select dbms_metadata.get_ddl('TABLE','T1') from dual;DBMS_METADATA.GET_DDL('TABLE',
-------------------------------------------------------------------------------- CREATE TABLE "SYS"."T1"
( "(asdada!!@#!)" NVARCHAR2(30) ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "SYSTEM"
SQL>
把TABLE换成vIEW,T1换成你的vIEW名称
SQL> SET LONG 10000;
SQL> SELECT TEXT
2 FROM ALL_VIEWS
3 WHERE OWNER = UPPER('DSS_DEV')
4 AND VIEW_NAME = UPPER('ALVW_AL_USAGE');TEXT
--------------------------------------------------------------------------------
(
select PARENT_OBJ,PARENT_OBJ_TYPE from AL_USAGE
union
select DESCEN_OBJ,DESCEN_OBJ_TYPE from AL_USAGE
)
SQL>