BINARY_INTEGER as loop counter
SQL>
SQL>
SQL> CREATE TABLE MyTable (
2 num_col NUMBER,
3 char_col VARCHAR2(60)
4 );
Table created.
SQL>
SQL>
SQL> DECLARE
2 v_LoopCounter BINARY_INTEGER := 1;
3 BEGIN
4 LOOP
5 INSERT INTO MyTable (num_col)
6 VALUES (v_LoopCounter);
7 v_LoopCounter := v_LoopCounter + 1;
8 EXIT WHEN v_LoopCounter > 50;
9 END LOOP;
10 END;
11 /
PL/SQL procedure successfully completed.
SQL>
SQL> select * from MyTable;
NUM_COL CHAR_COL
-------- ------------------------------------------------------------
1.00
2.00
3.00
4.00
5.00
6.00
7.00
8.00
9.00
10.00
11.00
NUM_COL CHAR_COL
-------- ------------------------------------------------------------
12.00
13.00
14.00
15.00
16.00
17.00
18.00
19.00
20.00
21.00
22.00
NUM_COL CHAR_COL
-------- ------------------------------------------------------------
23.00
24.00
25.00
26.00
27.00
28.00
29.00
30.00
31.00
32.00
33.00
NUM_COL CHAR_COL
-------- ------------------------------------------------------------
34.00
35.00
36.00
37.00
38.00
39.00
40.00
41.00
42.00
43.00
44.00
NUM_COL CHAR_COL
-------- ------------------------------------------------------------
45.00
46.00
47.00
48.00
49.00
50.00
50 rows selected.
SQL>
SQL> drop table MyTable;
Table dropped.
SQL>
SQL>
Related examples in the same category