1.复制表
create table dxxx as select * from zhzs_ahqscjdj_dxxx
或 create table dxxx1 as select * from zhzs_ahqscjdj_dxxx where 1=1 2.复制表结构 create table dxxx2 as select * from zhzs_ahqscjdj_dxxx where 1=0 原文链接：https://www.f2er.com/oracle/210260.html
1.复制表
create table dxxx as select * from zhzs_ahqscjdj_dxxx
或 create table dxxx1 as select * from zhzs_ahqscjdj_dxxx where 1=1 2.复制表结构 create table dxxx2 as select * from zhzs_ahqscjdj_dxxx where 1=0 原文链接：https://www.f2er.com/oracle/210260.html