Re: A job for two cursors?

From: Ubiquitous <weberm_at_polaris.net>
Date: Thu, 9 Oct 2003 11:48:54 +0000 (UTC)
Message-ID: <bm3hv6$366$1@news.utelfla.com>

Billy Verreynne <vslabs_at_onwe.co.za> wrote:

: As a rule. Cursors as this by implication deals with data on a
: row-by-row level. This can have huge performance implications. Rather
: attempt to deal with a data set as oppose to a row. Cursor processing
: is difficult to scale when dealing with large volumes of data.

Yes, I keep forgetting that ORACLE can perform data set operations, as opposed to the older databases I deal with.

Thanks all for your help! Received on Thu Oct 09 2003 - 06:48:54 CDT