oracle中的merge使用

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

MERGE INTO copy_emp c
	USING employees e
	ON (c.employee_id = e.employee_id)
WHEN MATCHED THEN
	UPDATE SET
		c.first_name = e.first_name,
		c.last_name = e.last_name,
		...
		c.department_id = e.department_id
WHEN NOT MATCHED THEN
	INSERT 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);