Oralce:
create table new_table as (select * from old_table)
sql server:
select * into new_table from old_table
db2:
create table new_table like old_table;
insert into new_table select * from old_table;
如果表已经有了,那末倒数据的sql为:
oracle:
insert into tablea_bak select * from tablea