--1 显示游标
declare
cursor v_sc1 isselect sendnum,registedate from user_info t for update of t.userlevel,nicheng nowait; --of 后面可以多个变量
n_level number;
n_sendnum number;
d_registedate date;
begin
n_level:=0;
open v_sc1;
loop
fetch v_sc1 into n_sendnum, d_registedate,n_id;
exit when v_sc1%notfound; --一定要有
if (n_sendnum>0) and (n_sendnum<=100) and (d_registedate<add_months(sysdate,-3))then
n_level :=1;
else
n_level :=3;
end if;
update user_info set userlevel = n_level where current of v_sc1; --更新数据 只更新当前数据;不用再次执行全表扫描
end loop;
end;
/
--2 带参数的游标
declare
cursor c_test(pid_1 number,pid_2 number