Exit a LOOP : Loop « PL SQL Statements « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. PL SQL Statements
  3. Loop
SQL>
SQL>
SQL>   BEGIN
  2         LOOP
  3              NULL;
  4              EXIT;
  5         END LOOP;
  6    END;
  7  /

PL/SQL procedure successfully completed.








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