Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using rowid to retrieve records

631319May 18 2010 — edited May 19 2010
I wonder if someone could tell me if it’s possible to do the following:

I would like to retrieve a collection of rowids such that each incremental rowid defines a certain number of records (200,000 in this example). Here’s how this might look:

Rowid(1)
Rowid(2)
Rowid(3)

Rowid(x)

Where: Select count(1) from table_a where rowid between rowid(1) and rowid(2)=200,000.

So, the question is – Is it possible to get the rowid for every 200,000th row in a large table?

I know, this seems pretty strange, and you no doubt wonder why I’m not using a user-defined key, but that’s impossible in this case.

Thanks for your help,

Tom
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 16 2010
Added on May 18 2010
12 comments
1,709 views