Oracle Merge into语句 USING?(SELECT?'1001'?AS?a,2?AS?b?FROM?dual)?T2ON?(?T1.a=T2.a)WHEN?MATCHED?THEN??UPDATE?SET?T1.b?=?T2.bWHEN?NOT?MATCHED?THEN???INSERT?(a,b)?VALUES(T2.a,T2.b);
?
ON?(?T1.a=T2.a)WHEN?MATCHED?THEN??UPDATE?SET?T1.b?=?T2.bWHEN?NOT?MATCHED?THEN???INSERT?(a,b)?VALUES(T2.a,T2.b);