游标分类:显示游标和隐含游标。
基本操作:声明游标、打开游标、提取游标、关闭游标。
声明游标:cursor cursor_name is select * from ....;
打开游标:
open cursor_name
提取游标:
fetch cursor_name into variable1,variable2,.........
例子:
open 游标;
loop
fetch 游标 into 变量;
exit when 游标%notfound
end loop;
关闭游标:
close cursor_name;
参数化游标:
cursor cursor_name(param in/out 类型) is select ......
游标循环:
open mycursor(periodId);
loop
fetch mycursor into temp_result;
exit when mycursor%notfound;
/*过程*/
end loop;
for temp_record in mycursor(periodId) loop
period:=temp_record.period ;
end loop;