EXIT a LOOP WHEN a certain condition : EXIT « PL SQL Statements « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. PL SQL Statements
  3. EXIT
SQL> set serveroutput on
SQL> set echo on
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 * mypi);
  7               v_Radius := v_Radius + 2;
  8               EXIT WHEN v_Radius > 10;
  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.








22.8.EXIT
22.8.1.EXIT a WHILE LOOP
22.8.2.EXIT WHEN
22.8.3.EXIT a FOR LOOP
22.8.4.Exit a function
22.8.5.EXIT statement with Label
22.8.6.Using 'EXIT WHEN' in a loop
22.8.7.EXIT a LOOP WHEN a certain condition
22.8.8.Exit to a Label