Oracle/PLSQL: Repeat Until Loop
来源:互联网 发布:淘宝盗用他人品牌授权 编辑:程序博客网 时间:2024/06/06 03:27
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;
{.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;
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为止
- Oracle/PLSQL: Repeat Until Loop
- repeat until
- Oracle/PLSQL: FOR Loop
- Oracle/PLSQL: While Loop
- Oracle/PLSQL: CURSOR FOR Loop
- lua的 repeat ..... until
- Oracle/PLSQL: FOR Loop 循环语句
- mysql 存储过程 REPEAT ... UNTIL ... END REPEAT
- lua中的repeat — until
- mysql while loop repeat
- mysql 循环while、loop、REPEAT
- plsql loop用法
- plsql loop循环
- PLSQL Cursor For Loop
- loop until ntp time is set
- oracle loop
- lua repeat until 先statement 后执行判断
- VBA 中 do-loop,do-while-loop,do-until-loop,for-each-next 的小例子
- asp.net中有四种页面跳转导航方式
- 用php实现gb2312和unicode间的编码转换
- 编写质量手册
- repeater实现多列显示
- 计算机中的原码、反码和补码
- Oracle/PLSQL: Repeat Until Loop
- 详细介绍ASP.NET状态保存方法
- 一款很好的Asp.net用的日期时间型控件
- SQL注入详解及示例
- 什么是病毒?病毒有几种表现形式?中毒以后一般怎么处理!
- INITIAL-D-SECOND STAGE - 第1话 『打破一切的超级武器』
- 关于23种设计模式的有趣见解
- 使用MessageWindows类从工作线程切换到UI线程
- JavaScript 实用脚本