Write a PL/SQL procedure to calculate the incentive on a target achieved and display the message either the record updated or not.
DECLARE PROCEDURE test1 ( sal_achieve NUMBER, target_qty NUMBER, emp_id NUMBER ) IS incentive NUMBER := 0; updated VARCHAR2(3) := 'No'; BEGIN IF sal_achieve > (target_qty + 200) THEN incentive := (sal_achieve - target_qty)/4; UPDATE emp SET salary = salary + incentive WHERE employee_id = emp_id; updated := 'Yes'; END IF; DBMS_OUTPUT.PUT_LINE ( 'Table updated? ' || updated || ', ' || 'incentive = ' || incentive || '.' ); END test1; BEGIN test1(2300, 2000, 144); test1(3600, 3000, 145); END; /
Sample Output:
Table updated? Yes, incentive = 75. Table updated? Yes, incentive = 150. PL/SQL procedure successfully completed.
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