Adding ELSE to the IF block

    

SQL>
SQL> -- Adding ELSE to the IF block.
SQL> set echo on
SQL> DECLARE
  2    v_HoursWorked Number := 50 ;
  3    v_OverTime Number ;
  4  BEGIN
  5    IF v_HoursWorked > 40 THEN
  6      v_OverTime := v_HoursWorked - 40;
  7         DBMS_OUTPUT.PUT_LINE('Hours overtime worked = ' || v_OverTime);
  8    ELSE
  9      v_OverTime := 0;
 10    END IF;
 11  END;
 12  /
Hours overtime worked = 10

PL/SQL procedure successfully completed.

SQL>

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.	IF, ELSIF ELSE and END IF
5.	Using nested IF statements
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

Adding ELSE to the IF block : IF « PL SQL « Oracle PL / SQL

Related examples in the same category