Oracle_复制表跟往表插数据

create table table_name as

select ...... from table table_name2

 

 

insert into table_name(field1,field2.....)

select .... from table_name2