UC知道急sql loop
来源：百度知道 编辑：UC知道 时间：2024/06/27 07:32:50
在sql 中要循环读游标 语法是什么~~~~
FOR @Count IN 1..5
LOOP
FETCH cur_count
INTO @NAME,@FLG
if @Count =1
select * from table1
if @Count =2
select * from table2
....
end loop
这样对吗~~~
FOR @Count IN 1..5
LOOP
FETCH cur_count
INTO @NAME,@FLG
if @Count =1
select * from table1
if @Count =2
select * from table2
....
end loop
这样对吗~~~
DECLARE CURSOR CUR_TEST IS SELECT * FROM table FOR UPDATE 表的一个字段;
I_ROW table%ROWTYPE;
BEGIN
OPEN CUR_TEST;
LOOP
FETCH CUR_TEST INTO I_ROW;
EXIT WHEN CUR_TEST%NOTFOUND;
你的处理语句
END LOOP;
CLOSE CUR_TEST;
END;