oracle数据库 merge into

create table TEST1 (ID INTEGER,VALUE VARCHAR2(255) );
insert into TEST1 values (1, ‘test1’);
insert into TEST1 values (2, ‘test2’);

select * from test1;

MERGE INTO TEST1 T1
USING (SELECT ‘2’ as ID, ‘newtest2’ as value FROM dual) T2 on (T1.ID=T2.ID)—判断id为2，value为newtest2的值是否存在
WHEN MATCHED THEN UPDATE SET T1.value=T2.value —存在更新
WHEN NOT MATCHED THEN INSERT (T1.ID, T1.value) VALUES (T2.ID, T2.value ); —不存在插入