SQL>
SQL> CREATE TABLE MyTable (
2 num_col NUMBER,
3 char_col VARCHAR2(60)
4 );
Table created.
SQL>
SQL>
SQL> DECLARE
2 v_Counter BINARY_INTEGER := 1;
3 BEGIN
4 LOOP
5 INSERT INTO MyTable
6 VALUES (v_Counter, 'Loop count');
7 v_Counter := v_Counter + 1;
8 IF v_Counter >= 50 THEN
9 GOTO l_EndOfLoop;
10 END IF;
11 END LOOP;
12
13 <>
14 INSERT INTO MyTable (char_col)
15 VALUES ('Done!');
16 END;
17 /
PL/SQL procedure successfully completed.
SQL> drop table MyTable;
Table dropped.
SQL>