特殊的insert语句(续)

  insert all
    
        into sal_history values(empid,hiredate,sal)

        into mgr_history values(empid,mgr,sal)
     
  select employee_id empid,manager_id mgr, salary sal,

        hire_date hiredate

  from employees

  where employee_id>200;

  insert all
    
         when sal>20000 then

         into sal_history values(empid,hiredate,sal)
        
         when mgr>200 then
        
         into mgr_history values(empid,mgr,sal)

  select employee_id empid,manager_id mgr,hire_date hiredate,
    
         salary sal
          
   from employees

   where employee_id>200;

   insert first
    
          when sal>50000 then
        
               into special_sal values(deptid,sal)

         when hiredate like ('%00%') then
        
               into hiredate_history_00 values (deptid,hiredate)

         when hiredate like ('%99%') then

               into hiredate_history_99 values (deptid,hiredate)

   select department_id deptid,sum(salary)sal,max(hire_date) hiredate
         
   from employees

   group by department_id