1、oracle的open for fetch语法
oracle的open for fetch语法
open for fetch是一种游标循环方式。
open c1 for '动态sql' [using];
loop
fetch c1 into [table]
exit when c1%notfound;
...
end loop;
使用示例：
declare
type cur_model_type is ref cursor;
c1 cur_model_type;
v_task_code tab_test.task_code%type;
v_draw_type tab_test.draw_type%type;
begin
open c1 for 'select task_code,draw_type from tab_test where rownum = 1';
loop
fetch c1 into v_task_code,v_draw_type;--每次循环出来接收的参数
exit when c1%notfound;--没有记录时停止
dbms_output.put_line('v_task_code:'||v_task_code||',v_draw_type:'||v_draw_type);
end loop;
close c1;
end;