Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Searching no-unique data chunks by index
I want to be able to return only a segment of the rows based on a
non-primary non unique key. I want to be able to go forwards or
backwards based on the key keeping the position between sessions. This
is a huge table so "scrolling" is necessary. I have considered a
composite index which is made of of a unique field + the PK but cannot
seem to retreive based on this index starting on a key. Is it possible
to reteive the data in this form?
Received on Mon Aug 23 1999 - 13:25:09 CDT
![]() |
![]() |