User Tools

Site Tools


kurs:calc_bonus
FUNCTION CALC_BONUS
  ( salary IN number,
    hiredate IN date )
  -- berechnet einen 20%igen Bonus
  /* Das ist ein mehrzeiliger
  Kommentar
  */
  RETURN  number IS
  bonus EMPLOYEES.salary%Type;
  bonus_percentage number(9,2);
BEGIN 
    select GET_NUMPARAM('bonus_percentage') into bonus_percentage from dual;
    bonus := salary*bonus_percentage/100;
--    if hiredate < sysdate - to_yminterval('10-0') oder:
    if (extract(year from sysdate) - extract(year from hiredate)) >= 10
    then bonus := bonus + 100;
    end if;
    
    RETURN bonus;
END;
kurs/calc_bonus.txt · Last modified: 2014/09/10 21:22 (external edit)