﻿ PL/SQL Control Statement: Incentive achieved according to the specific sale limit - w3resource

# PL/SQL Control Statement Exercises: Incentive achieved according to the specific sale limit

## PL/SQL Control Statement: Exercise-6 with Solution

Write a PL/SQL procedure to calculate the incentive achieved according to the specific sale limit.

Sample Solution:

PL/SQL Code:

``````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.
```

Flowchart:

Improve this sample solution and post your code through Disqus

What is the difficulty level of this exercise?

﻿