请帮忙看一下两段SQL语句是否一样

[zhujiaozi]

第一段
update pay_source_all p set (bfzt,djqrsj,zfzhid,qp1,qp2,qp3,zflx,zxcw)=(select i.bfzt,i.djqrsj,i.zfzhid,i.qp1,i.qp2,i.qp3,i.zflx,i.zxcw
from pay_SOURCE i
where i.zdlsh=p.zdlsh and i.yhzh=p.yhzh and i.hm=p.hm and to_char(i.je,'999999.99')=to_char(p.je,'999999.99') )
where exists (select 1
from pay_SOURCE i
where i.zdlsh=p.zdlsh and i.yhzh=p.yhzh and i.hm=p.hm and to_char(i.je,'999999.99')=to_char(p.je,'999999.99')
) and p.qp3='201811278756420'

第二段

merge into pay_source_all p
using (select i.bfzt,i.djqrsj,i.zfzhid,i.qp1,i.qp2,i.qp3,i.zflx,i.zxcw,i.zdlsh,i.yhzh,i.hm,i.je from pay_SOURCE i ) t
on ( t.zdlsh=p.zdlsh and t.yhzh=p.yhzh and t.hm=p.hm and to_char(t.je,'999999.99')=to_char(p.je,'999999.99') and p.qp3='201811278756420')
when matched then
update set p.bfzt = t.bfzt , p.djqrsj=t.djqrsj,p.qp1=t.qp1,p.qp2=t.qp2,p.qp3=t.qp3,p.zflx=t.zflx,p.zxcw=t.zxcw;

[yaiger]

测试一下就行了
不过merge into要仔细测一下，效率比较高，但是容易写错，要当心

[Mricoo_周]

没啥区别，效果是一样的，可能效率会不一样 ，具体看表的体量

[卖水果的net]

效果是一样的，要注意的是，源表的数据，必须是唯一的。