FETCH需要显式声明游标,显式打开、关闭游标。
FOR不需要显式声明游标,是隐式打开、关闭游标
1、FETCH循环
open cursor_a;
loop
fetch cursor_a into rec;
exit when cursor_a%notfound;
......
end loop;
close cursor_a;
2、FOR循环
for rec in cursor_a loop
......
end loop;
3、单纯循环n次
FOR i IN 1..n LOOP
.....
END LOOP;
4、批量处理
open cursor_a ;
FETCH cursor_a BULK COLLECT INTO rec_list;
......
CLOSE cursor_a ;