|
进行merge的时候不小心粘贴错了,将source.PENDINGID写成了source.dest.PENDINGID,可以运行不报错但是数据加倍了。
忽略了source. 而且发现source.换成abc.也不报错。
MERGE INTO dest_table dest
USING source_table source
ON (source.PENDINGCODE = dest.PENDINGCODE and source.PENDINGPERSONID = dest.PENDINGPERSONID)
WHEN MATCHED THEN
UPDATE SET dest.PENDINGID = source.dest.PENDINGID
WHEN NOT MATCHED THEN
INSERT
VALUES
(source.PENDINGID, source.PENDINGCODE, source.PENDINGTITLE, source.PENDINGDATE, source.PENDINGSENDER, source.PENDINGPERSONID, source.PENDINGURL, source.PANDINGSTATUS, source.PANDINGCITYCODE, source.PANDINGTYPE, source.NOTE);
|
|