EXIT WHEN : EXIT « PL SQL Statements « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. PL SQL Statements
  3. EXIT
SQL>
SQL> set serveroutput on
SQL> set echo on
SQL>
SQL>    DECLARE
  2         v_Radius NUMBER := 2;
  3     BEGIN
  4         WHILE TRUE LOOP
  5              DBMS_OUTPUT.PUT_LINE('The Area is ' ||mypi * v_Radius * v_Radius);
  6              EXIT WHEN v_RADIUS = 10;
  7              v_Radius := v_Radius + 2 ;
  8         END LOOP;
  9    END;
 10    /
The Area is 12.56
The Area is 50.24
The Area is 113.04
The Area is 200.96
The Area is 314

PL/SQL procedure successfully completed.

SQL>








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