Re: Possible Tune-up?

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 28 Jul 2006 14:19:49 -0700
Message-ID: <1154121589.854548@bubbleator.drizzle.com>

Frank van Bortel wrote:
> 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 ;)

Alas it was Fat Tire not Chimay.

And for American beers: Fat Tire is one of the very best. But it is not Chimay. Allagash Curieux ... now that is the equal but very hard to find. http://www.allagash.com/beer.htm

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Fri Jul 28 2006 - 16:19:49 CDT