CREATE OR REPLACE FUNCTION CalculSommeSalaire
  RETURN NUMBER
IS
  CURSOR cur_sal
  IS
    SELECT * FROM salaries;
  var_sal salaries%ROWTYPE;
  total NUMBER:=0;
BEGIN
  total:=0;
  OPEN cur_sal;
  LOOP
    FETCH cur_sal INTO var_sal;
    EXIT
  WHEN cur_sal%notfound;
    IF(var_sal.comission IS NULL) THEN
      total:=total+var_sal.salaire+NVL(var_sal.comission,0);
    ELSE
      total:=total+var_sal.salaire+var_sal.comission;
    END IF;
  END LOOP;
  CLOSE cur_sal;
RETURN total;
END CalculSommeSalaire;
--
CREATE OR REPLACE FUNCTION CalculMoyenneSalaire(
    somme NUMBER)
  RETURN NUMBER
IS
  total NUMBER:=0;
BEGIN
  SELECT COUNT(*) INTO total FROM salaries;
  total:=somme/total;
  RETURN total;
END CalculMoyenneSalaire;
--