Untitled

PL/SQL |

720 B

None

0 👍

0 👎

Raw Download Clone Embed Print View

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;
--

Comments

01/01/70 12:00:00 AM UTC
Plain Text |
0 B
|
👍
/
👎
01/01/70 12:00:00 AM UTC
Plain Text |
0 B
|
👍
/
👎

Pasted

Untitled

Comments