Write a PL/SQL procedure to calculate the incentive achieved according to the specific sale limit.
DECLARE PROCEDURE test1 (sal_achieve NUMBER) IS incentive NUMBER := 0; BEGIN IF sal_achieve > 44000 THEN incentive := 1800; ELSIF sal_achieve > 32000 THEN incentive := 800; ELSE incentive := 500; END IF; DBMS_OUTPUT.NEW_LINE; DBMS_OUTPUT.PUT_LINE ( 'Sale achieved : ' || sal_achieve || ', incentive : ' || incentive || '.' ); END test1; BEGIN test1(45000); test1(36000); test1(28000); END; /
Sample Output:
Sale achieved : 45000, incentive : 1800. Sale achieved : 36000, incentive : 800. Sale achieved : 28000, incentive : 500. 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