将a表结构复制给b表 create table b as select * from a where 1<>1
可能是书写语法有无呐!SQL> create table test1 as select * from test where 1=2;Table createdSQL> select * from test1;USERNAME USERNUM -------------------- ---------------------------------------SQL> alter table test1 add(adress varchar2(20));Table alteredSQL> select * from test1;USERNAME USERNUM ADRESS -------------------- --------------------------------------- --------------------SQL>
create table b as select * from a where 1<>1
-------------------- ---------------------------------------SQL> alter table test1 add(adress varchar2(20));Table alteredSQL> select * from test1;USERNAME USERNUM ADRESS
-------------------- --------------------------------------- --------------------SQL>