Oracle行列转换的简单实现

最新推荐文章于 2024-07-31 14:31:55 发布

sunhao20032003

最新推荐文章于 2024-07-31 14:31:55 发布

阅读量201

点赞数

本文链接：https://blog.csdn.net/sunhao20032003/article/details/53700744

版权

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;