Mega Code Archive
FOR Loops
<![CDATA[
A FOR loop runs a predetermined number of times.
The syntax for a FOR loop is as follows:
FOR loop_variable IN [REVERSE] lower_bound..upper_bound LOOP
statements
END LOOP;
where
loop_variable specifies the loop variable.
REVERSE specifies that the loop variable value is to be decremented each time through the loop.
lower_bound specifies the loop's lower bound.
upper_bound specifies the loop's upper bound.
If REVERSE is used, the loop variable is initialized to this upper bound.
SQL>
SQL> set serveroutput on
SQL> BEGIN
2 FOR just_a_num IN 1..10
3 LOOP
4 dbms_output.put_line(just_a_num);
5 END LOOP;
6 END;
7 /
1
2
3
4
5
6
7
8
9
10
PL/SQL procedure successfully completed.
SQL>
]]>