17,088
社区成员
发帖
与我相关
我的任务
分享
declare
sp t_sp.sp%type;
cursor c_sp is select sp from t_sp;
begin
--加一个这个dbms_output.enable(99999999999999);
dbms_output.enable(99999999999999);
open c_sp;
loop
fetch c_sp into sp;
exit when c_sp%notfound;
dbms_output.put_line('我是游标:' || sp);
end loop;
close c_sp;
end;
declare
cursor csr_sp is select sp from t_sp;
row_t_sp csr_sp%type;
begin
open csr_sp;
for row_t_sp in csr_sp
loop
dbms_output.put_line('我是游标:' || row_t_sp.sp );
end loop;
close csr_sp;
end;