w3resource

PL/SQL Control Statement Exercises: Calculate the incentive on a specific target otherwise a general incentive to be paid using IF-THEN-ELSE

PL/SQL Control Statement: Exercise-4 with Solution

Write a PL/SQL procedure to calculate the incentive on a specific target otherwise a general incentive to be paid using IF-THEN-ELSE.

Sample Solution:

PL/SQL Code:

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

Flowchart:

Flowchart: PL/SQL Control Statement Exercises: Calculate the incentive on a specific target otherwise a general incentive to be paid using IF-THEN-ELSE

Improve this sample solution and post your code through Disqus

Previous: Write a PL/SQL program to check whether a number is even or odd.
Next: Write a PL/SQL program to check whether a date falls on weekend i.e. SATURDAY or SUNDAY.

What is the difficulty level of this exercise?



Inviting useful, relevant, well-written and unique guest posts