Clase de hoy: Resolvimos el problema de la clase pasada. [Parte 2]

Declare
Cursor myCursor is Select department_id, count(*) as "total empleados"
from employees
where Department_id is not null;
group by department_id
order by department_id;
vDepartamento employees.employee_id%type;
vTotalEmpleados integer;
vNomDepto varchar2(30);
Begin
 Open myCursor;
 Loop
     FETCH myCursor into vDepartamento, VTotalEmpleados;
Exit when myCursor%NOTFOUND;
Select Department_Name into vNomDepto
From Departments
     where department_id = vDepartamento;
DBMS_output.put_line(vNomDepto||' '||vTotalEmpleados);
end Loop;
Close myCursor;

End

Declare
Cursor myCursor is Select department_id, count(*) as "total empleados"
from employees
where Department_id is not null
group by department_id
order by department_id;
vDepartamento employees.employee_id%type;
vTotalEmpleados integer;
Begin
 Open myCursor;
 Loop
     FETCH myCursor into vDepartamento, VTotalEmpleados;
Exit when myCursor%NOTFOUND;
DBMS_output.put_line(vDepartamento||' '||vTotalEmpleados);
end Loop;
Close myCursor;

End




declare
vNumDepto integer := 10;
vNomDepto varchar2(30);

Begin
Select Department_Name into vNomDepto
From Departments
where department_id = 10;
DBMS_output.put_line('El codigo del departamento es : '||vNumDepto);
DBMS_output.put_line('El codigo del departamento es : '||vNomDepto);
End