PLSQL:Exit Statement
来源:互联网 发布:阿里云防cc攻击 编辑:程序博客网 时间:2024/05/22 11:42
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循环就会终止。
0 0
- Oracle/PLSQL: Exit Statement
- PLSQL:Exit Statement
- Oracle/PLSQL: Case Statement
- Oracle/PLSQL: FETCH Statement
- Oracle/PLSQL: OPEN Statement
- Oracle / PLSQL: ALTER TABLE Statement
- PLSQL:用exit代替continue
- COBOL GOBACK & STOP RUN & EXIT PROGRAM 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
- - Statement
- statement
- Statement
- statement
- statement
- statement
- rman体系结构
- Junit4.X使用教程
- BZOJ 2002 弹飞绵羊 Link-Cut-Tree(LCT)
- 区分现有的vc工程是有哪一版本的工具开发?
- 常用的正则表达式测试工具
- PLSQL:Exit Statement
- LeetCode110——Balanced Binary Tree
- 一,超猪聊技术----jdk对象序列化协议
- 撤销和闪回技术
- BZOJ大视野 1191: [HNOI2006]超级英雄Hero
- Core Animation 叠加
- javafX初探(滚动条)
- sharepoint 列表文件夹的基本操作(增、删、改、查)
- android Asynctask和handler的区别是什么?优缺点各是什么?能否同时并发100+asyncTask呢?