Using EXIT with a FOR loop : EXIT « PL SQL « Oracle PL / SQL






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

Using EXIT with a FOR loop

 

SQL>
SQL> -- Using EXIT with a FOR loop.
SQL> BEGIN
  2        FOR i IN 1..20 LOOP
  3             IF MOD(i,2) = 0 THEN
  4                  DBMS_OUTPUT.PUT_LINE('The AREA of the circle is ' || i*i * mypi);
  5             END IF;
  6             IF i = 10 THEN
  7                  EXIT;
  8             END IF;
  9        END LOOP;
 10   END;
 11  /
The AREA of the circle is 12.56
The AREA of the circle is 50.24
The AREA of the circle is 113.04
The AREA of the circle is 200.96
The AREA of the circle is 314

PL/SQL procedure successfully completed.

SQL>
SQL>








Related examples in the same category

1.Impact of EXIT in a function
2.Using EXIT with a simple LOOP
3.Using EXIT with a WHILE loop
4.Unconstrained loop: exit
5.Exit outer loop with 'EXIT LabelName When' statement
6.EXIT WHEN clause.
7.Exit to a label
8.Exit loop since last index value is read.