Oracle merge用法(实现多表更新插入)

merge into sk_kskc a(目标表)using (select yk_ypcd.ypxh as ypxh,yk_ypcd.ypcd as ypcd,bfbz,zxbz ,lsjg
  from yk_typk ,yk_ypcd where yk_typk.ypxh=yk_ypcd.ypxh) b(数据来源)
on (a.wpxh=b.ypxh and a.wpcd=b.ypcd  
 and a.ksdm=414 and a.wplx=0)(目标与来源的条件关联)
when matched then update set a.wpdj = b.lsjg/b.zxbz * b.bfbz(匹配成功进行更新操作)

when not matched then insert (a.wpxh,a.wpcd,a.wpdj) values (b.ypxh,b.ypcd, b.lsjg/b.zxbz * b.bfbz)(匹配不成功进行插入操作);