＋设为首页 ＋添加到收藏夹
当游标没记录时，我查到的资料都是exit操作，如下：
fetch cur_servhis into thisservhis;
exit when cur_servhis%notFound;
我现在需要当没记录时，要执行一个insert操作，请问怎么写？
open cur_servhis;
loop
fetch cur_servhis into thisservhis;
exit when cur_servhis%notFound;
end loop;
if cur_servhis%rowcount = 0 then
insert into ......
end if;
close cur_servhis;
.....
open c;
loop
fetch c into user_id,user_name;
if c%rowcount=0 then
insert into dinya_user values(1,E);
commit;
exit;
end if;
end loop;
close c;
end ;
