统计每年入职的员工个数

/*
统计每年入职的员工个数
*/

set serveroutput on
declare
  --光标保存员工
  cursor  c1 is select to_char(hiredate,'yyyy') from emp;
  pdate  VARCHAR2(4);--保存具体的时间
 
  --计数器保存每年员工个数
  count80 number :=0;
  count81 number :=0;
  count82 number :=0;
  count87 number :=0;
 
begin
  open c1;
  loop
    fetch c1 into pdate;
    --退出条件
    exit when c1%notfound;
    --判断年份
    if pdate = '1980' then count80 := count80 + 1;
    ELSIF pdate = '1981' then count81 := count81 + 1;
    ELSIF pdate = '1982' then count82 := count82 + 1;
    ELSIF pdate = '1987' then count87 := count87 + 1;
    end if;
  end loop; 
  close c1;
 
  dbms_output.put_line('总数：' || (count80 + count81 + count82 + count87));
  dbms_output.put_line('80人数：' || count80);
  dbms_output.put_line('81人数：' || count81);
  dbms_output.put_line('82人数：' || count82);
  dbms_output.put_line('87人数：' || count87);
end;
/