select to_char(HIREDATE,'yyyy'),count(*) from emp group by to_char(HIREDATE,'yyyy');
plsql:
set serveroutput on;
declare
cursor cemp is select to_char(HIREDATE,'yyyy') from emp ;
phiredate varchar2(4);
count80 number:=0;
count81 number:=0;
count87 number:=0;
count82 number:=0;
begin
open cemp;
loop
fetch cemp into phiredate;
exit when cemp%notfound;
if phiredate = '1980' then count80:=count80+1;
elsif phiredate = '1982' then count82:=count82+1;
elsif phiredate = '1987' then count87:=count87+1;
else count81:=count81+1;
end if;
end loop;
close cemp;
DBMS_OUTPUT.PUT_LINE('1980'||'--'||count80);
DBMS_OUTPUT.PUT_LINE('1981'||'--'||count81);
DBMS_OUTPUT.PUT_LINE('1982'||'--'
1.统计每年的入职人数sql:select to_char(HIREDATE,'yyyy'),count(*) from emp group by to_char(HIREDATE,'yyyy');plsql:set serveroutput on;declare cursor cemp is select to_char(HIREDATE,'yyyy') from emp ; p...