declare
vtem yourtable%rowtype;
cursor curtem is
select * from yourtable;
begin
open curtem;
loop
fetch curtem into vtem;--这里的vtem就是一条条的记录了。
exit when curtem%notfound;
end loop;
close curtem;
end;
vtem yourtable%rowtype;
cursor curtem is
select * from yourtable;
begin
open curtem;
loop
fetch curtem into vtem;--这里的vtem就是一条条的记录了。
exit when curtem%notfound;
end loop;
close curtem;
end;
select yourfield into yourarray from yourtable 直接这样使用呢。