create or replace procedure p_test
is
cr NE_INFO%ROWTYPE;
begin
select * INTO cr
From NE_INFO where rownum=1;
end p_test;
/
is
cr NE_INFO%ROWTYPE;
begin
select * INTO cr
From NE_INFO where rownum=1;
end p_test;
/
多者用游标(cursor)。
is
cr NE_INFO%ROWTYPE;
cursor cur_a is
select * From NE_INFO;
begin
open cur_a;
loop
fetch cur_a into cr;
exit when cur_a%NOTFOUND;
end loop;
close cur_a;
end p_test;
/