Se va actualiza tabelul COPY_EMP pe baza valorilor din tabelul EMPLOYEES

UPDATE copy_emp

    SET   department_id= (SELECT department_id
                        FROM employees
                        WHERE employee_id =100)
    WHERE job_id= (SELECT job_id
                                FROM employees
                                WHERE employee_id =200);