oracle sql 记录存在则更新，不存在则插入

最新推荐文章于 2024-04-11 15:33:37 发布

earthhour

最新推荐文章于 2024-04-11 15:33:37 发布

阅读量4.5k

点赞数 1

分类专栏： oracle sql

本文链接：https://blog.csdn.net/earthhour/article/details/9399291

版权

sql 同时被 2 个专栏收录

3 篇文章 0 订阅

订阅专栏

oracle

1 篇文章 0 订阅

订阅专栏

MERGE <hint> INTO <table_name>
USING <table_view_or_query>
ON (<condition>)
WHEN MATCHED THEN <update_clause>
DELETE <where_clause>
WHEN NOT MATCHED THEN <insert_clause>

[LOG ERRORS <log_errors_clause> <reject limit <integer | unlimited>];

MERGE INTO USERINFO a
USING (
  SELECT '1' as UNAME
  FROM dual
  ) b
ON (a.UNAME = b.UNAME)
WHEN MATCHED THEN
  UPDATE SET a.ADDR = 'ddd', a.UTC = 1234567
WHEN NOT MATCHED THEN
  INSERT (a.ADDR, a.UTC, a.UNAME) VALUES ('aaa', 7654321, '1');