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为止