-- 增加temp_khlxfs2表,存放不相同的记录,然后再去更新 add by ljh 20120730
insert into temp_khlxfs2(lxfshm,gxrq,gxsj,gxyg,khbh,lxfsbh)
Select a.Lxfshm,
To_Char(Sysdate, 'YYYYMMDD') Gxrq,
To_Char(Sysdate, 'hh24:mi:ss') Gxsj,
1 Gxyg,
a.khbh,
a.lxfsbh
From TEMP_KHLXFS a
where Exists (Select 1
From t_khlxfs t
Where t.Khbh = a.Khbh
And a.Lxfsbh = t.Lxfsbh
And a.lxfshm <> t.lxhm);
Dbms_Output.put_line(' count is '||sql%rowcount);
--对比更新 add by lisw 20120615
Update /*+parallel(t 8) */ t_Khlxfs a
Set (a.Lxhm, a.Gxrq, a.Gxsj, a.Gxyg) = (Select b.lxfshm,b.gxrq,b.gxsj,b.gxyg
From Temp_Khlxfs2 b
Where a.Khbh = b.Khbh And a.Lxfsbh = b.Lxfsbh And a.Lxhm <> b.Lxfshm)
Where Exists (Select 1 From Temp_Khlxfs2 t Where t.Khbh = a.Khbh And a.Lxfsbh = t.Lxfsbh And a.Lxhm <> t.Lxfshm);