--更新错误信息分级表,没有记录时则插入新数据
MERGE INTO test1 a
USING (SELECT v_f001 AS f001,
v_f002 AS f002
FROM DUAL) b
ON (a.f001 = b.f001)
WHEN MATCHED THEN
UPDATE
SET a.f01 = b.f001,
a.f002 = v.f002
WHEN NOT MATCHED THEN
INSERT
(f001,
f002
)
VALUES
(b.f001,
b.f002
);
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24805255/viewspace-721346/,如需转载,请注明出处,否则将追究法律责任。