Oracle/PLSQL: Repeat Until Loop

 

Oracle/PLSQL: Repeat Until Loop

---

Oracle doesn't have a Repeat Until loop, but you can emulate one. The syntax for emulating a REPEAT UNTIL Loop is:

译： Oracle 中没有 Repeat Until loop ，但是你可以仿照一个。仿照一个 Repeat Until loop 的语法如下

LOOP
     {.statements.}
     EXIT WHEN boolean_condition;
END LOOP;

You would use an emulated REPEAT UNTIL Loop when you do not know how many times you want the loop body to execute. The REPEAT UNTIL Loop would terminate when a certain condition was met.

译：当你不知道你的循环要执行多少次的时候，你就可以使用 Repeat Until loop 。当遇到一个指定条件的时候， Repeat Until loop 就会终止。

Let's take a look at an example:

LOOP
     monthly_value := daily_value * 31;
     EXIT WHEN monthly_value > 4000;
END LOOP;

In this example, the LOOP would repeat until the monthly_value exceeded 4000.

译：在该示例中，LOOP循环会一直直到 monthly_value 的值大于 4000 为止