merge into用法

原创 Linux操作系统作者：dingyu220 时间：2012-04-16 17:10:53 0 删除编辑

--更新错误信息分级表,没有记录时则插入新数据
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/，如需转载，请注明出处，否则将追究法律责任。