MERGE INTO copy_emp c
USING employees e
ON (c.employee_id = e.employee_id)
WHEN MATCHED THEN
  UPDATE SET c.salary = e.salary
WHEN NOT MATCHED THEN
  INSERT (employee_id, last_name, salary)
  VALUES (e.employee_id, e.last_name, e.salary);

もう少し詳しく