建一个和原表一样的备份表(包括数据)或表已经有了,那末倒数据的sql

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 * fromtablea