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 )