等同于重复密钥更新的Oracle DB [英] Oracle DB equivalent of on duplicate key update
本文介绍了等同于重复密钥更新的Oracle DB的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我需要在Oracle中执行以下MySQL查询:
I need to execute the following MySQL-query in Oracle:
INSERT INTO users VALUES(1,10) ON DUPLICATE KEY UPDATE points = 10;
除了merge
之外还有其他内容吗?我只是不明白.
Is there something else besides merge
? I just don't understand it.
推荐答案
您将需要使用MERGE
.像
MERGE INTO users dest
USING( SELECT 1 user_id, 10 points FROM dual) src
ON( dest.user_id = src.user_id )
WHEN MATCHED THEN
UPDATE SET points = src.points
WHEN NOT MATCHED THEN
INSERT( user_id, points )
VALUES( src.user_id, src.points );
这篇关于等同于重复密钥更新的Oracle DB的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文