FUNCTION SQL DEVELOPER database ORACLE

membuat function dengan database ORACLE ada juga yang menggunakan if


SCRIPT function

CREATE OR REPLACE FUNCTION
salgros (esal IN NUMBER)
RETURN NUMBER
AS
hasil NUMBER;
BEGIN
HASIL:= 12* esal;
RETURN HASIL;
END;

SELECT first_name, job_id, salgros(SALARY) FROM HR.EMPLOYEES

CREATE OR REPLACE FUNCTION
fpajak (esal IN NUMBER)
RETURN NUMBER
AS
pajak NUMBER;
BEGIN
IF salgros(esal) kurang dari 100000 THEN pajak := 0.45*salgros(esal);
ELSIF salgros(esal) BETWEEN 80000 AND 99999 THEN pajak := 0.35*salgros(esal);
ELSIF salgros(esal) BETWEEN 60000 AND 79999 THEN pajak := 0.25*salgros(esal);
ELSIF salgros(esal) BETWEEN 40000 AND 59999 THEN pajak := 0.15*salgros(esal);
ELSE pajak := 0.05*salgros(esal);
END IF;
RETURN pajak;
END;

SELECT first_name, job_id, salgros(SALARY),fpajak(SALARY) FROM HR.EMPLOYEES

CREATE OR REPLACE FUNCTION
fbonus (esal IN NUMBER)
RETURN NUMBER
AS
bonus NUMBER;
BEGIN
IF fpajak(esal) kurang dari 100000 THEN bonus := 0.05*fpajak(esal);
ELSIF fpajak(esal) BETWEEN 80000 AND 79999 THEN bonus := 0.1*fpajak(esal);
ELSIF fpajak(esal) BETWEEN 40000 AND 59999 THEN bonus := 0.15*fpajak(esal);
ELSE bonus := 0.2*fpajak(esal);
END IF;
RETURN bonus;
END;
SELECT first_name, job_id, salgros(SALARY),fpajak(SALARY),fbonus(SALARY) FROM HR.EMPLOYEES

CREATE OR REPLACE FUNCTION
fgatot (esal IN NUMBER)
RETURN NUMBER
AS
total NUMBER;
BEGIN
total := salgros(esal)-fpajak(esal)+fbonus(esal);
RETURN total;
END;
SELECT first_name, job_id, salgros(SALARY),fpajak(SALARY),fbonus(SALARY),fgatot(SALARY) FROM HR.EMPLOYEES


silahkan komentar jika bingung ya