Insert a row into MyTable with the current value of the loop counter.

  

SQL>
SQL>
SQL> CREATE TABLE MyTable (
  2    num_col    NUMBER,
  3    char_col   VARCHAR2(60)
  4    );

Table created.

SQL>
SQL> DECLARE
  2    v_Counter BINARY_INTEGER := 1;
  3  BEGIN
  4    LOOP
  5      INSERT INTO MyTable
  6        VALUES (v_Counter, 'Loop index');
  7      v_Counter := v_Counter + 1;
  8      IF v_Counter > 50 THEN
  9        EXIT;
 10      END IF;
 11    END LOOP;
 12  END;
 13  /

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL> drop table MyTable;

Table dropped.

SQL>
SQL>

Related examples in the same category

1.	Use EXIT WHEN to exit a loop
2.	Empty Loop statement
3.	unconstrained loop
4.	Loop with label
5.	LOOP..END LOOP, Cursor Loop
6.	An anonymous block demonstrates a guard on exit simple loop

Insert a row into MyTable with the current value of the loop counter. : Loop « PL SQL « Oracle PL / SQL

Related examples in the same category