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')