LOOP END LOOP : Loop « PL SQL Statements « Oracle PL/SQL Tutorial






SQL>
SQL> SET ECHO ON
SQL> SET SERVEROUTPUT ON
SQL>
SQL>
SQL> DECLARE
  2    hundreds_counter  NUMBER(1,-2);
  3  BEGIN
  4    hundreds_counter := 100;
  5    LOOP
  6      DBMS_OUTPUT.PUT_LINE(hundreds_counter);
  7      hundreds_counter := hundreds_counter + 100;
  8    END LOOP;
  9  EXCEPTION
 10  WHEN OTHERS THEN
 11    DBMS_OUTPUT.PUT_LINE('Done.');
 12  END;
 13  /
100
200
300
400
500
600
700
800
900
Done.

PL/SQL procedure successfully completed.

SQL>








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