Write a PL/SQL procedure to calculate the incentive on a specific target otherwise a general incentive to be paid using IF-THEN-ELSE.
DECLARE PROCEDURE test1 ( sal_achieve NUMBER, target_qty NUMBER, emp_id NUMBER ) IS incentive NUMBER := 0; BEGIN IF sal_achieve > (target_qty + 200) THEN incentive := (sal_achieve - target_qty)/4; ELSE incentive :=75; END IF; DBMS_OUTPUT.PUT_LINE ('incentive = ' || incentive); UPDATE emp SET salary = salary + incentive WHERE employee_id = emp_id; END test1; BEGIN test1(2300, 2000, 144); test1(3600, 3000, 145); END; /
Sample Output:
incentive = 75 incentive = 150
total answers (1)
start bookmarking useful questions and collections and save it into your own study-lists, login now to start creating your own collections.
Sample Output:
need an explanation for this answer? contact us directly to get an explanation for this answer