Use EXIT WHEN to exit a loop

  
SQL>
SQL>    DECLARE
  2          v_Radius NUMBER := 2;
  3     BEGIN
  4          LOOP
  5               DBMS_OUTPUT.PUT_LINE('The AREA of the circle is '
  6                    || v_RADIUS*v_RADIUS);
  7               v_Radius := v_Radius + 2;
  8               EXIT WHEN v_Radius > 10;
  9          END LOOP;
 10    END;
 11  /
The AREA of the circle is 4
The AREA of the circle is 16
The AREA of the circle is 36
The AREA of the circle is 64
The AREA of the circle is 100

PL/SQL procedure successfully completed.

SQL> --

Related examples in the same category

1.	Empty Loop statement
2.	unconstrained loop
3.	Loop with label
4.	LOOP..END LOOP, Cursor Loop
5.	Insert a row into MyTable with the current value of the loop counter.
6.	An anonymous block demonstrates a guard on exit simple loop

Use EXIT WHEN to exit a loop : Loop « PL SQL « Oracle PL / SQL

Related examples in the same category