/*
DROP TABLE statDepEmp;

CREATE TABLE statDepEmp(
numDept       NUMBER(2) NOT NULL PRIMARY KEY,
nbEmp         NUMBER(2),
totalSalaire  NUMBER(9,2)
);
*/

CREATE OR REPLACE PACKAGE packEmp AS -- spec
PROCEDURE pIniStat;
FUNCTION nouvSalaire(salaire NUMBER, pourcentage NUMBER) RETURN NUMBER;
END packEmp;
/

CREATE OR REPLACE PACKAGE BODY packEmp AS  -- body

  PROCEDURE pIniStat IS

   CURSOR emp_cursor IS
     SELECT EMP.numDept, COUNT(EMP.matrEmp) as nombre, NVL(SUM(EMP.salaireEmp), 0) as sommeSalaire
     FROM EMP
     LEFT OUTER JOIN DEPT ON EMP.numDept = DEPT.numDept
     GROUP BY EMP.numDept;

   BEGIN
      FOR i IN emp_cursor
      LOOP
        INSERT INTO statDepEmp VALUES(i.numDept, i.nombre, i.sommeSalaire);
      END LOOP;

   END pIniStat;

  FUNCTION nouvSalaire(salaire NUMBER, pourcentage NUMBER) RETURN NUMBER IS
   BEGIN
     return 8;
   END nouvSalaire;

END packEmp;
/

begin
packEmp.pIniStat;
DBMS_OUTPUT.PUT_LINE('test');
end;