在ORACLE和sql server中简单备份table的方法

如果temp_t1不存在，

 

oracle:

 

create table temp_t1

as

select * from t1

 

sql server:

 

select * into temp_t1 from t1

 

如果temp_t1存在，

 

oracle:

 

insert into table temp_t1

select * from t1

 

sql server:

 

insert into table temp_t1

select * from t1