Re: How can I selec rows in physical order?

if you do a select without any order by clause then you will get the rows as retrieved from the tablespace - is this what you mean by physical order?

It would be a real chore (i think) to decode the ROWID psuedocolumn into some disk mapping of sectors (blocks really) and then order those somehow within tablespaces...

hope this helps.
randy

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.
Received on Thu Jun 22 2000 - 00:00:00 CDT