FOR Loop Ranges with variable
SQL>
SQL> CREATE TABLE MyTable (
2 num_col NUMBER,
3 char_col VARCHAR2(60)
4 );
Table created.
SQL>
SQL>
SQL> DECLARE
2 v_LowValue NUMBER := 10;
3 v_HighValue NUMBER := 40;
4 BEGIN
5 FOR v_Counter IN REVERSE v_LowValue .. v_HighValue LOOP
6 INSERT INTO MyTable
7 VALUES (v_Counter, 'Dynamically specified loop ranges');
8 END LOOP;
9 END;
10 /
PL/SQL procedure successfully completed.
SQL>
SQL>
SQL>
SQL> select * from MyTable;
NUM_COL CHAR_COL
---------- ------------------------------------------------------------
40 Dynamically specified loop ranges
39 Dynamically specified loop ranges
38 Dynamically specified loop ranges
37 Dynamically specified loop ranges
36 Dynamically specified loop ranges
35 Dynamically specified loop ranges
34 Dynamically specified loop ranges
33 Dynamically specified loop ranges
32 Dynamically specified loop ranges
31 Dynamically specified loop ranges
30 Dynamically specified loop ranges
NUM_COL CHAR_COL
---------- ------------------------------------------------------------
29 Dynamically specified loop ranges
28 Dynamically specified loop ranges
27 Dynamically specified loop ranges
26 Dynamically specified loop ranges
25 Dynamically specified loop ranges
24 Dynamically specified loop ranges
23 Dynamically specified loop ranges
22 Dynamically specified loop ranges
21 Dynamically specified loop ranges
20 Dynamically specified loop ranges
19 Dynamically specified loop ranges
NUM_COL CHAR_COL
---------- ------------------------------------------------------------
18 Dynamically specified loop ranges
17 Dynamically specified loop ranges
16 Dynamically specified loop ranges
15 Dynamically specified loop ranges
14 Dynamically specified loop ranges
13 Dynamically specified loop ranges
12 Dynamically specified loop ranges
11 Dynamically specified loop ranges
10 Dynamically specified loop ranges
31 rows selected.
SQL>
SQL> drop table MyTable;
Table dropped.
Related examples in the same category