Re: How can I selec rows in physical order?

From: <sergey_s_at_my-deja.com>
Date: 2000/06/22
Message-ID: <8irudk$74v$1@nnrp1.deja.com>#1/1

How about in the order in which they were originally inserted? Granted that there were only inserts into the table.

Sergey

In article <3952223f.9830485_at_super.news-ituk.to>, See Message body for real address wrote:
>
> The 'physical order' ( if by that you mean the actual location of each
record
> on the storage device) of data in an Oracle database is
undeterminable....
>
> Rownum is a counter that limits the # of rows returned...
>
> sergey_s_at_my-deja.com wrote:
>
> >Does ROWNUM guarantee physical order of the rows in a table?
> >If not, how can I get rows out in their physical order?
> >
> >Thanks!
> >
> >Sergey
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jun 22 2000 - 00:00:00 CDT