学步园

  -- 增加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);