Loop exit when condition : Repeat Until « PL SQL « Oracle PL / SQL

1. Oracle PL / SQL
2. PL SQL
3. Repeat Until

Loop exit when condition

SQL>
SQL> SET SERVEROUTPUT ON
SQL> DECLARE
  2      counter INTEGER := 2;
  3  BEGIN
  4
  5    LOOP
  6       counter := counter + 1;
  7       DBMS_OUTPUT.PUT_LINE(counter);
  8    EXIT WHEN counter = 5;
  9
 10    END LOOP;
 11
 12  END;
 13  /
 
 
 
 
 
3
4
5

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL>
           
       

Related examples in the same category