Oracle更新多行

 

Oracle更新多行

更新多行的步骤：

步骤多，但效率比较高： 
1、create table 临时表 value (select a.id,a.name,b.name,... from table1 a,table2 b where a.id=b.id) 
2、删除table1中的记录，不要drop 
3、insert into table1 select 你需要的字段 from 临时表。

 

 

select * from tb_ai03

create table tb_ai031 as select * from tb_ai03

delete  from tb_ai03 a where a.yymm in ('200911','200910')

insert into tb_ai03 
select a.model,a.yysal/b.unitestrip as yysal ,a.mmsal/b.unitestrip as mmsal,
a.yychu/b.unitestrip as yychu,a.mmchu/b.unitestrip as mmchu,a.yymm 
from tb_ld04 b,tb_ai031 a 
where a.model=b.model(+) and a.yymm in ('200911','200910')