Oracle merge into 使用記錄

標籤：

符合條件進行更新操作，不符合則進行插入操作．

merge into myd_nsrdt nusing (select ‘9‘as mydtmid,‘1‘as tmtype,‘370200123456788‘as nsrsbh,‘‘ as nsrmc,  ‘sn‘ as region,4 as pf,‘‘as yj,‘18888888888‘ as phone,‘18888888888‘ as nowphone,sysdate as addtime from dual) mon(n.mydtmid=m.mydtmid and n.nsrsbh=m.nsrsbh)when matched then  update set n.pf=m.pf,n.yj=m.yj    where n.mydtmid=m.mydtmid and n.nsrsbh=m.nsrsbhwhen not matched then  insert values(seq_myd.nextval,m.mydtmid,m.tmtype,m.nsrsbh,m.nsrmc,m.region,m.pf,m.yj,m.phone,m.nowphone,m.addtime)

 

Oracle merge into 使用記錄