Re: How to move cursor to skip couple of record.

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Wed, 12 May 1999 14:43:42 -0400
Message-ID: <7hchvd$g8v$1@autumn.news.rcn.net>

Hi,

You can, but you shouldn't. Oracle does not store data in a predictable sequence. If you are inserting a new row into a table it may be inserted anywhere. As a result you have no way of knowing what the 10th row in the table contains. If you have already retrieved the 10th row in the table and you know you will want to access again just save the unique key or the rowid of the row and use one or the other when you want to access that same row in the future.

regards

Jerry Gitomer

Peizhong Wu wrote in message <3739C2C5.31D7B844_at_umich.edu>...
>HI,
>
>How can I move cursor to #10 record without fetch the first 9 records?
>
>Thanks
>
>
Received on Wed May 12 1999 - 13:43:42 CDT