Re: Holdable cursors in Oracle?

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Thu, 20 Mar 2003 07:29:42 +0000
Message-ID: <b5bjit$a1g$2@ctb-nnrp2.saix.net>

DA Morgan wrote:

> The shareable cursor if I recall correctly is a standard feature in
> Teradata

Daniel, any idea why cursors needs to be sharable across sessions in Teradata?

> and I have reason to believe Oracle may be using them but not
> explicitly: Not as a developer defined cursor type.

Yes, that I can believe. A shareable cursor in such a "system's context" is simply a representation in memory of the physical table on disk.

--
Billy

Received on Thu Mar 20 2003 - 01:29:42 CST