fetch和for循环

xiaoxiao2021-03-01  26

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;

转载请注明原文地址: https://www.6miu.com/read-4200106.html

最新回复(0)