casul2deldia

CREATE OR REPLACE FUNCTION f_calcularComissio (salari NUMBER) RETURN NUMBER IS
  comissio NUMBER;
BEGIN
comissio := CASE
            WHEN salari<=3000 THEN 0.15
            WHEN salari BETWEEN 3001 AND 7000 THEN 0.10
            WHEN salari BETWEEN 7001 AND 10000 THEN 0.05
            WHEN salari BETWEEN 10001 AND 20000 THEN 0.01
            ELSE NULL
          END;
  return comissio;
END;

SELECT employee_id, first_name, salary, f_calcularComissio(salary)
FROM employees;