Oracle/PLSQL: FOR Loop

 

Oracle/PLSQL: FOR Loop

---

The syntax for the FOR Loop is:

FOR loop_counter IN [REVERSE] lowest_number..highest_number
LOOP
     {.statements.}
END LOOP;

You would use a FOR Loop when you want to execute the loop body a fixed number of times.

译：当你需循环体执行一定的次数的时候，就可以使用FOR Loop。

Let's take a look at an example.

FOR Lcntr IN 1..20
LOOP
     LCalc := Lcntr * 31;
END LOOP;

This example will loop 20 times. The counter will start at 1 and end at 20.

译：这个示例将会循环20次，计数器将会从1到20。

The FOR Loop can also loop in reverse. For example:

译：FOR循环也可以反向循环（这里就是计数器从高到低），如：

FOR Lcntr IN REVERSE 1..15
LOOP
     LCalc := Lcntr * 31;
END LOOP;

This example will loop 15 times. The counter will start at 15 and end at 1. (loops backwards)

译：该示例将会循环15次。计数器将会从15到1（从后到前）。