FOR…LOOP is an iterative control. It is used when iterations need to occur a fixed number of times.
FOR counter IN [REVERSE] start_range.. end_range LOOP
Statements;
END LOOP;
By default, iteration proceeds upward from the start range to the end range. But if the keyword REVERSE is used, iteration proceeds downward from the end range to the start range.
Note: The range is part of an iteration scheme, which is enclosed by the keywords FOR and LOOP. A double dot (..) serves as the range operator.
Click here to get free oracle-pl-sql Oracle PL/SQL Developer exam practice questions.
Best exam simulation Oracle 1Z0-001 download free trial.
Like this article? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.