Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> cursor result return
Hi all,
when I try to select * from test_table it takes 9 seconds. (4000
records)
but when I try to run this in PL/SQL
declare
cursor c_bill is
select * from test_table
begin
for l_c_bill in c_bill loop
dbms_output.put_line (l_c_bill.rownum) ;
end loop;
end;
it take more then 588 seconds, it's anyway to reduce this time in
pl/sql?
Thanks Received on Mon Feb 21 2005 - 15:08:18 CST
![]() |
![]() |