declare
v_col1 table.col1%type;
cursor cur is select col1 from table where 1=1 ;
begin
open cur;
loop
fetch cur into v_col1;
exit when cur%notfound;
– doing
end loop;
close cur ;
end;
Oracle 之 cursor 游标
最新推荐文章于 2024-08-16 16:19:07 发布
declare
v_col1 table.col1%type;
cursor cur is select col1 from table where 1=1 ;
begin
open cur;
loop
fetch cur into v_col1;
exit when cur%notfound;
– doing
end loop;
close cur ;
end;