MERGE INTO emp e
USING emp_ref s
ON (e.emp_id = s.emp_id)
WHEN MATCHED THEN UPDATE
SET e.name = s.name
WHEN NOT MATCHED THEN INSERT (emp_id, name … )
VALUES (emp_id, name … );