// 创建表
create table ORACLE_TEST(
ID number(10) primary key,
ROT varchar2(20) not null,
SOG varchar2(4)
);
// MERGE INTO语句
MERGE INTO ORACLE_TEST dest USING (
SELECT
'125891' AS ID,
'11223344' AS ROT,
'99887766' AS SOG
FROM
dual
) src ON (dest.ID = src.ID)
WHEN MATCHED THEN
UPDATE
SET
dest.ROT = src.ROT,
dest.SOG = src.SOG
WHEN NOT MATCHED THEN
INSERT (ID, ROT, SOG)
VALUES
(src.ID, src.ROT, src.SOG)