Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Searching no-unique data chunks by index

Searching no-unique data chunks by index

From: <dirk.blevins_at_wcom.com>
Date: Mon, 23 Aug 1999 18:25:09 GMT
Message-ID: <37C192B9.846939F5@wcom.com>


 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US