Re: Possible Tune-up?

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 28 Jul 2006 20:54:22 +0200
Message-ID: <eadm9c$eo3$4@news6.zwoll1.ov.home.nl>

DA Morgan schreef:

> Adley wrote:

>> Peace all,
>>
>> This is actually my friend's question. He is the developer here. The
>> main problem is the PL/SQL script written below. It will be very slow
>> when trying to fetch a lot of rows, in the range of thousands.
>>
>> The Oracle version is still 8.1.7 on AIX 4.3.
[SNIP!]
> But assuming you could not ... there is essentially no valid reason > to ever use a cursor loop in Oracle unless you have a Neolithic version.

They have, Daniel, they have.

And you should stay away from the Chimay until all mail is *read* and answered ;)

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Fri Jul 28 2006 - 13:54:22 CDT