MERGE INTO <表名1 [エイリアス名] USING 表名2 | 副問い合わせ [エイリアス名] ON ( <結合条件> ) WHEN MATCHED THEN UPDATE SET <カラム名> = < 値 >, … WHEN NOT MATCHED THEN INSERT [ (<カラム名>, … ) ] VALUES ( <値> , … ) ;
MERGE INTO [TABLE1] A
USING ( SELECT 'TEST' COL1,
1 NUM1
FROM DUAL) B
ON (A.COL1 = B.COL1
AND A.NUM1 = B.NUM1)
WHEN MATHCED THEN
UPDATE
SET A.[COLUMN] = [DATA],
A.[COLUMN] = [DATA]
WHEN NOT MATHCED THEN
INSERT(COL1,NUM1,.....)
VALUES(COL1,NUM1,.....);