Re: Go backwards in a fetch on oracle 7.3

From: Michael Krolewski <vandra_at_u.washington.edu>
Date: Sat, 24 Oct 1998 14:29:28 -0700
Message-ID: <363246B8.83AEB59B@u.washington.edu>

No. The fetch is one directional. This is consistent with the idea that others could be changing and commiting the changes to the table(s) that you are viewing.

If you use fetch blocks, you can programatically look backward within the array.
If you are selecting small sets of rows -- use a fetch block that is larger. You can
than review any record in the fetch.

By the way, fetching by block is more effecient than a single record. However,
it requires more programming to support fully.

Mike Krolewski

Saul Mond wrote:

> Is it possible to go backwards in a fetch using oracle 7.3. . Please
> email me at smond_at_cyberdude.com
Received on Sat Oct 24 1998 - 16:29:28 CDT