Przykład:

MERGE INTO bonuses b
USING (select employee_id, department_id, salary from employees where department_id in (20, 40)) t2
ON (b.employee_id = t2.employee_id)
WHEN
MATCHED THEN UPDATE set b.bonus = b.bonus * 1.1
WHEN NOT MATCHED THEN INSERT (b.employee_id, b.department_id, b.salary)
values (t2.employee_id, t2.department_id, t2.salary)


Przykład pobrany z kursu Oracle SQL na platformie Udemy.