INSERT INTO oldemployee(employee_id, department_name, hire_date, salary)SELECT a.employee_id, b.department_name, a.hire_date, a.salaryFROM employee a, department bWHERE a.department_id = b.department_id AND a.hire_date <TO_DATE('2019-01-01', 'YYYY-MM-DD'); 1. 单位给所有的员工涨...