Oracle Merge into话语

2013-04-02

Oracle Merge into语句USING?(SELECT?1001?AS?a,2?AS?b?FROM?dual)?T2ON?(?T1.aT2.a)WHEN?MATCHED?THEN

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