cursor que lista la cantidad de empleados por departamentos

declare
cursor curCtaEmpleados is
select DEPARTMENT_ID, count(*)
from employees
group by DEPARTMENT_ID
order by count(*) desc, DEPARTMENT_ID;
vIdDepartamento employees.DEPARTMENT_ID%type;
vTotalEmpleados integer;
vNombreDepartamento departments.department_name%type;
begin
open curCtaEmpleados;
loop
fetch curCtaEmpleados into vIdDepartamento, vTotalEmpleados;
exit when curCtaEmpleados%NOTFOUND;
select department_name into vNombreDepartamento
from departments
where department_id = vIdDepartamento;
-- vNombreDepartamento := 'Ventas';
dbms_output.put_line(vIdDepartamento || ' '||vNombreDepartamento || ' ' ||vTotalEmpleados);
end loop;
close curCtaEmpleados;
end