Oracle行列转换的简单实现

declare
  cursor cemp is select to_char(HIREDATE,'yyyy') from emp;
  phiredate varchar2(4);
  count80 number:=0;
  count81 number:=0;
  count82 number:=0;
  count87 number:=0;
begin
  open cemp;
       loop
         fetch cemp into phiredate;
         exit when cemp%notfound;
         if phiredate = '1980' then count80:=count80+1;
         elsif phiredate = '1981' then count81:=count81+1;
         elsif phiredate = '1982' then count82:=count82+1;
         else count87:=count87+1;
         end if;
       end loop;
       dbms_output.put_line('total|'||'1980|'||'1981|'||'1982|'||'1987');
       dbms_output.put_line((count80+count81+count82+count87)||'|'||count80||'|'||count81||'|'||count82||'|'||count87);
  close cemp;
end;