Oracle merge into 使用记录

myd_nsrdt n using (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) m on(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.nsrsbh when 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 使用记录

标签：

本文系统来源：http://www.cnblogs.com/yshyee/p/4529619.html

【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！