pl/sql中for loop
来源:互联网 发布:单片机红外发射电路图 编辑:程序博客网 时间:2024/05/16 07:01
Oracle/PLSQL: FOR Loop
The syntax for the FOR Loop is:
FOR loop_counter IN [REVERSE] lowest_number..highest_number
LOOP
{.statements.}
END LOOP;
You would use a FOR Loop when you want to execute the loop body a fixed number of times.
Let's take a look at an example.
FOR Lcntr IN 1..20
LOOP
LCalc := Lcntr * 31;
END LOOP;
This example will loop 20 times. The counter will start at 1 and end at 20.
The FOR Loop can also loop in reverse. For example:
FOR Lcntr IN REVERSE 1..15
LOOP
LCalc := Lcntr * 31;
END LOOP;
This example will loop 15 times. The counter will start at 15 and end at 1. (loops backwards);
and there is another use:
DECLARE
BEGIN
FOR eno IN (SELECT empno AS id FROM emp WHERE emp.empno IN (7900, 7902))
LOOP
INSERT INTO new_emp
(employee_id,
NAME)
SELECT t.empno,
t.ename
FROM emp t
WHERE t.empno = eno.id;
COMMIT;
END LOOP;
END;
- pl/sql中for loop
- PL/SQL for loop
- pl/sql 中for和while循环([PL/SQL] 用For Loop 替代Cursor)
- [PL/SQL] 用For Loop 替代Cursor
- [PL/SQL] 用For Loop 替代Cursor
- PL/SQL中if,case,loop使用
- Oracle:PL/SQL--流程控制(三)——循环结构:loop、while-loop、for-loop
- PL/SQL LOOP Construct
- pl/sql loop循环
- oracle pl sql loop循环
- PL/SQL的loop循环
- 【DB.PL/SQL】程序流程控制 —— 循环 ——LOOP, END LOOP, WHILE, FOR, CONTINUE
- PL/SQL基础编程之(四) [LOOP WHILE FOR][异常处理、自定义异常]
- ORACLE PL/SQL基础 选择(IF CASE) 、 循环(LOOP WHILE FOR)
- pl/sql中的控制语句应用: 循环语句 loop和for
- PL/SQL 中的nested loop code
- pl/sql存储过程loop死循环
- Oracle pl/sql编程 11---loop循环
- Qt中translate、tr关系 与中文问题
- 备份表
- JAVA线程
- 软件项目经理怎么做?
- java转义和linux系统重启服务
- pl/sql中for loop
- 中国缺乏研究的人才
- android项目中如何加载已有so库
- 名词解释
- wondows自带的防火墙打不开,弹出个窗口“由于相关服务没有运行,windows防火墙设置无法显示
- 1.如何获得当前文件路径
- linux变量介绍
- 华清远见教材目录
- cocos2d-x 让游戏画面变暗