Oracle/PLSQL: Exit Statement
来源:互联网 发布:js半圆形仪表盘占比 编辑:程序博客网 时间:2024/05/16 04:33
Oracle/PLSQL: Exit Statement
The syntax for the EXIT statement is:
译:EXIT statement的语法如下:
EXIT [WHEN boolean_condition];
The EXIT statement is most commonly used to terminate LOOP statements.
译:EXIT statement通常用于终止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 terminate when the monthly_value exceeded 4000.
译:在这个示例中,当monthly_value的值大于4000的时候,LOOP循环就会终止
- Oracle/PLSQL: Exit Statement
- PLSQL:Exit Statement
- Oracle/PLSQL: Case Statement
- Oracle/PLSQL: FETCH Statement
- Oracle/PLSQL: OPEN Statement
- Oracle / PLSQL: ALTER TABLE Statement
- Oracle/PLSQL: WHERE CURRENT OF Statement
- Oracle/PLSQL: WHERE CURRENT OF Statement
- Oracle/PLSQL: WHERE CURRENT OF Statement
- Oracle/PLSQL: WHERE CURRENT OF Statement
- PLSQL:用exit代替continue
- oracle plsql
- oracle plsql
- oracle plsql
- oracle--PLSQL
- oracle plsql
- COBOL GOBACK & STOP RUN & EXIT PROGRAM STATEMENT
- Oracle sql statement tuning
- Smartupload和commons-fileupload介绍与比较(ZT)
- 内核中的调度与同步
- 将动态aspx页面转换成为静态html页面的几种方法
- E文积累_20071030
- 给求职遇到困难的毕业生的建议
- Oracle/PLSQL: Exit Statement
- 利用ASP.Net状态保存的视图机制记录网页内部参数值
- 取代微軟之難 -- SQL Server 第三方軟件篇
- .Net Micro Framework研究—TCP/IP通信
- 请不要做浮躁的人!
- Google Server Error
- Rational 统一过程
- 弹出对话框的同时保持页面的显示
- 质量管理的十三项步骤和八项原则(1)