/*
统计每年入职的员工个数
*/
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;
/