Creating a REPEAT...UNTIL Loop : Loop « PL SQL Statements « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. PL SQL Statements
  3. Loop

The Syntax for a Simulated REPEAT...UNTIL Loop

LOOP
    <statements>
       IF <condition is true>
            EXIT;
       END IF;
  END LOOP;

Alternatively, you could use the preferable method of

LOOP
    <statements>
       EXIT WHEN <condition is true>;
  END LOOP;








22.3.Loop
22.3.1.Loops
22.3.2.Simple Loops
22.3.3.LOOP END LOOP
22.3.4.Count up by hundreds until we get an error
22.3.5.The EXIT WHEN statement can appear anywhere in the loop code.
22.3.6.Exit a LOOP
22.3.7.EXIT a LOOP for a certain condition
22.3.8.Nested loops: Loop inside of a Loop
22.3.9.Exiting from Nested Loops
22.3.10.Using Labels and EXIT Statements with Loops
22.3.11.Creating a REPEAT...UNTIL Loop
22.3.12.Use LOOP to insert data to a table
22.3.13.Fetch Cursor data in LOOP
22.3.14.A SQL Replacement for Regular Loops
22.3.15.Named loop block