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 -> Re: How can I selec rows in physical order?

Re: How can I selec rows in physical order?

From: TurkBear <johng_at_mm.com>
Date: 2000/06/21
Message-ID: <3952223f.9830485@super.news-ituk.to>#1/1

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! =----- Received on Wed Jun 21 2000 - 00:00:00 CDT

Original text of this message

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