Oracle 之 cursor 游标

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;