Re: cursor result return

zibinyang_at_gmail.com wrote:

> 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

9 seconds is horrifying. 588 seconds ... I've seen better performance from a stack of 3x5 cards.

What version on what hardware?

Sybrand may well be correct about the difference ... but 9 seconds is unbelievably slow.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)