oracle中的merge使用

merge语句同时执行插入【insert】和更新语句【update】

MERGE INTO copy_emp cUSING employees eON (c.employee_id = e.employee_id)WHEN MATCHED THENUPDATE SETc.first_name = e.first_name,c.last_name = e.last_name,...c.department_id = e.department_idWHEN NOT MATCHED THENINSERT VALUES(e.employee_id, e.first_name, e.last_name,e.email, e.phone_number, e.hire_date, e.job_id,e.salary, e.commission_pct, e.manager_id,e.department_id);