1 MERGE INTO 2 table-name 2 view-name 3? correlation-clause 4 USING table-reference ON search-condition 5+ 5 WHEN matching-condition THEN 5.1 modification-operation 5.1 signal-statement 6! ELSE IGNORE 6? 7! ATOMIC 7? 7 NOT ATOMIC 7.1 STOP ON SQLEXCEPTION 7.1 CONTINUE ON SQLEXCEPTION correlation-clause 1! AS 2 correlation-name 3? ( 3.1+ , 3.1 column-name 3.2 ) matching-condition 1? NOT 2 MATCHED 3? AND search-condition modification-operation 1 UPDATE 1.1? 1.1 OVERRIDING SYSTEM VALUE 1.1 OVERRIDING USER VALUE 1.2 SET assignment-clause 1 DELETE 1 insert-operation assignment-clause 1.0+ , 1.0 column-name = 1.0.1 expression 1.0.1 DEFAULT 1.0.1 NULL 1.0 ( 1.0.1+ , 1.0.1 column-name 1.0.2 ) = ( 1.0.3.0+ , 1.0.3.0 expression 1.0.3.0 DEFAULT 1.0.3.0 NULL 1.0.3 row-fullselect 1.0.4 ) 1 ROW = ( 1.1.0+ , 1.1.0 expression 1.1.0 DEFAULT 1.1.0 NULL 1.1 row-fullselect 1.2 ) insert-operation 1 INSERT 2? 2 ( 2.1+ , 2.1 column-name 2.2 ) 2.2.1? 2.2.1 OVERRIDING SYSTEM VALUE 2.2.1 OVERRIDING USER VALUE 3 VALUES 4.0 expression 4.0 DEFAULT 4.0 NULL 4 ( 4.1+ , 4.1 expression 4.1 DEFAULT 4.1 NULL 4.2 )