merge语法

MERGE INTO bonuses D             ---（要进行修改的表）
USING (SELECT employee_id, salary, department_id FROM employees
WHERE department_id = 80) S       ---（数据来源表）
ON (D.employee_id = S.employee_id)---（关联条件）
WHEN MATCHED THEN

UPDATE SET D.bonus = D.bonus + S.salary*.01   ---（注意语法）
DELETE WHERE (S.salary > 8000)
WHEN NOT MATCHED THEN

INSERT (D.employee_id, D.bonus)               ----（注意语法）
VALUES (S.employee_id, S.salary*.01)
WHERE (S.salary <= 8000);