Re: How can I selec rows in physical order?

From: Niall Litchfield <niall.litchfield_at_doial.pipex.com>
Date: 2000/06/22
Message-ID: <8it99g$gdh$1@soap.pipex.net>#1/1

Prior to Oracle 8 you could - I believe do this using ROWID. After Oracle8 the file reference is relative and I believe that you cannot do what you wish to.

I would strongly question the motivation for doing this - In an RDBMS (any RDBMS) the concept of first record does not really exist. Why do you wish to do such an apparently absurd thing?

--
Niall Litchfield
Oracle DBA
Audit Commission UK
<sergey_s_at_my-deja.com> wrote in message news:8ir4mg$kqa$1_at_nnrp1.deja.com...


> 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.

Received on Thu Jun 22 2000 - 00:00:00 CDT