Oracle Merge into语句
USING?(SELECT?'1001'?AS?a,2?AS?b?FROM?dual)?T2
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);
?
?
发布时间： 2013-04-02 12:35:26 作者： rapoo
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);
?
?