fetch和for循环

fetch需要显式声明游标，显式打开、关闭游标。 for不需要显式声明游标，是隐式打开、关闭游标。 1、fetch循环

open cursor_a; loop fetch cursor_a into rec; exit when cursor_a%not found; ...... 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;