Re: Returning Rows in Random Order

From: William Bailey <billbailey64_at_netzero.net>
Date: Thu, 08 Mar 2001 01:37:57 GMT
Message-ID: <VnBp6.3263$68.713600@typhoon.tampabay.rr.com>

Technically, SQL always returns rows in a random order ... i.e. there is no guarantee what order they will be returned in ... this is why ORDER BY is required if you want a specific order. So what I suppose you mean is that you want the rows to be returned in a different order each time you select from the table ... as far as I'm aware, there is no way to do this in Oracle ... the rows MAY be returned in a different order from one select to the next, but there is no way to guarantee it.

I'm curious .. why in the world would you need to do this?

"jack straw" <sacque_at_yahoo.com> wrote in message news:9859pv$kj0$1_at_linux1.netconx.de...
> Is there a way to return rows from a SELECT statement in a random order?
I
> have found ways to do it in SQL server, but not in Oracle.
>
> please help!
> thanks
>
>
>
>
Received on Wed Mar 07 2001 - 19:37:57 CST