Oracle MERGE 不插入
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/2336330/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
提示：将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间：2020-09-18 20:05:12 来源:igfitidea点击:
Oracle MERGE does not INSERT
提问by Jalil
I have this simple example I can't seems to get working :
我有这个简单的例子，我似乎无法开始工作：
MERGE INTO mytable mt
USING dual
ON (mt.id = 'AAA' )
WHEN MATCHED THEN
UPDATE SET mt.name = 'updated'
WHEN NOT MATCHED THEN
INSERT (mt.id , mt.name )
VALUES ('AAA', 'Gooood' );
If a 'AAA' record exists in the table, it is updated successfully.
如果表中存在“AAA”记录，则更新成功。
But if does not exists, it is not inserted :
但如果不存在，则不会插入：
Affected rows: 0
Time: 0.003ms
Any clue on what I am doing wrong ?
关于我做错了什么的任何线索？
回答by Tony Andrews
Works for me:
对我有用：
SQL> create table mytable (id varchar(3), name varchar(30));
Table created.
SQL> MERGE INTO mytable mt
2 USING dual
3 ON (mt.id = 'AAA' )
4 WHEN MATCHED THEN
5 UPDATE SET mt.name = 'updated'
6 WHEN NOT MATCHED THEN
7 INSERT (mt.id , mt.name )
8 VALUES ('AAA', 'Gooood' );
1 row merged.
SQL> select * from mytable;
ID NAME
--- ------------------------------
AAA Gooood
