Merge statements

The MERGE statement updates a target with specified input data.

The target of a MERGE statement can be a table or a view. Rows in the target that match the input data are updated as specified, and rows that do not exist in the target are inserted. You also can use a MERGE statement with host-variable arrays to insert and update data. The MERGE statement can also update underlying tables or views of a fullselect.