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

Home -> Community -> Usenet -> c.d.o.server -> query question

query question

From: Karl Hungus <nnnnndddddd_at_hotmail.com>
Date: Thu, 01 Apr 2004 18:48:52 GMT
Message-ID: <ouZac.12$mX.175700@twister.nyc.rr.com>

I would like to cycle through records (rows) one at a time in a table. My primary key is not contiguous -- Im using a sequence to set it on insert.

whats the best way to structure the query to get a single record, and get the primary key of the records before and after the current record? (eg., for prev/next buttons)

TIA,
Karl Received on Thu Apr 01 2004 - 12:48:52 CST

Original text of this message

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