Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> cursor result return

cursor result return

From: <zibinyang_at_gmail.com>
Date: 21 Feb 2005 13:08:18 -0800
Message-ID: <1109020098.389102.250010@z14g2000cwz.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US