Exit a loop with condition : IF « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. IF

Exit a loop with condition

     
SQL>
SQL> SET ECHO ON
SQL>
SQL> DECLARE
  2      v_MyNumber NUMBER := 0;
  3  BEGIN
  4      LOOP
  5          IF v_MyNumber > 7 THEN
  6              EXIT;
  7          ENd if;
  8          v_MyNumber := v_MyNumber + 1;
  9      END LOOP;
 10  END;
 11  /

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL>
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.Adding ELSE to the IF block
5.IF, ELSIF ELSE and END IF
6.Using nested IF statements
7.Using IF...ELSIF to determine a grade
8.if then else
9.A conditional statement
10.Check number value in if statement
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