Title: (Optional) Construct a MERGE statement.
Course: Database Design and Management (Oracle) (10052) > Section: Applying Data Manipulation Language

Construction should include using the following format:

MERGE INTO table-name USING table/view/subquery
ON  what join condition
WHEN MATCHED THEN UPDATE SET
Col1 = Col2 value
WHEN NOT MATCHED THEN
INSERT (column_list)
VALUES (column_values)