MERGE INTO T_APP_TJWT T1 --要插入或更新的表即要判断的表
USING (SELECT '1001' AS a,'1111' AS b,'3333' as C FROM dual) T2 --判断数据的表
ON ( T1.WTID=T2.a AND T1.WTSM=T2.b)
WHEN MATCHED THEN --如有则更新
UPDATE SET T1.tjr = T2.c
WHEN NOT MATCHED THEN --如无则插入
INSERT (wtid) VALUES(T2.a);
更新或插入部分可注释
USING (SELECT '1001' AS a,'1111' AS b,'3333' as C FROM dual) T2 --判断数据的表
ON ( T1.WTID=T2.a AND T1.WTSM=T2.b)
WHEN MATCHED THEN --如有则更新
UPDATE SET T1.tjr = T2.c
WHEN NOT MATCHED THEN --如无则插入
INSERT (wtid) VALUES(T2.a);
更新或插入部分可注释