FOR index IN [REVERSE] n .. m
LOOP
(...)
END LOOP;
Where n and m represent the interval limits. Notice that n should be less or equal to m, even in case we specify the REVERSE option. In case n equals m, the loop would be executed just once. If n is greater than m, the control goes after the end of the loop.
Here is a FOR loop that prints the number 1, 2 and 3, each on its own line:
for my_value in 1 .. 3
loop
dbms_output.put_line(my_value);
end loop;
And here is a countdown:
for my_value in reverse 1 .. 3
loop
dbms_output.put_line(my_value);
end loop;
The fifth chapter of Oracle PL/SQL Programming, fifth edition, by Steven Feuerstein is about loops.
No comments:
Post a Comment