A numeric FOR loop with insert statement
SQL>
SQL> CREATE TABLE MyTable (
2 num_col NUMBER,
3 char_col VARCHAR2(60)
4 );
Table created.
SQL>
SQL>
SQL> BEGIN
2 FOR v_LoopCounter IN 1..50 LOOP
3 INSERT INTO MyTable (num_col)
4 VALUES (v_LoopCounter);
5 END LOOP;
6 END;
7 /
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>
Related examples in the same category