Using nested IF statements

    

SQL>
SQL>
SQL> -- Using nested IF statements.
SQL> DECLARE
  2    v_HoursWorked Number := 80 ;
  3    v_OverTime Number := 0 ;
  4    v_PayType char(1) := 'E';
  5
  6  BEGIN
  7     IF v_HoursWorked > 40 THEN
  8       IF v_PayType = 'H' THEN
  9         v_OverTime := v_HoursWorked - 40;
 10         DBMS_OUTPUT.PUT_LINE('Hours overtime worked = ' || v_OverTime);
 11      ELSE
 12         IF v_PayType = 'S' THEN
 13            DBMS_OUTPUT.PUT_LINE('Employee is Salaried');
 14         ELSE
 15            DBMS_OUTPUT.PUT_LINE('Employee is Executive Management');
 16         END IF;
 17      END IF;
 18     END IF;
 19  END;
 20  /
Employee is Executive Management

PL/SQL procedure successfully completed.

Related examples in the same category

1.	IF...ELSIF...ELSE... END IF
2.	The IF statement contains more than one statement per condition.
3.	IF THEN and END IF
4.	Adding ELSE to the IF block
5.	IF, ELSIF ELSE and END IF
6.	Using IF...ELSIF to determine a grade
7.	if then else
8.	A conditional statement
9.	Check number value in if statement
10.	Exit a loop with condition
11.	If ladder
12.	Compare three variables with if statement
13.	If count() is 0, insert data
14.	If condition meets, throw exception
15.	Nested if statement
16.	If...then...Else
17.	Using a Boolean variable instead of the comparison operation
18.	An if-then-elsif-then-else statement where the first two comparisons are true and the third false
19.	Create a function and call it in an if statement

Using nested IF statements : IF « PL SQL « Oracle PL / SQL

Related examples in the same category