Re: Returning Rows in Random Order

[Quoted] well, there is an index unfortunately :(

"Happl Oberlin" <happl_at_mail.com> wrote in message news:happl-F778E4.14173507032001_at_news.fu-berlin.de...
> In article <985a58$kl9$1_at_linux1.netconx.de>, "jack straw"
 <sacque_at_yahoo.com> wrote:
>
> >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.
>
> If there is no ORDER BY or GROUP BY in the query and
> ORACLE does not use an index to retrieve the data,
> the rows are returned in random order.
>
> Greetings from Switzerland -- Gruesse aus der Schweiz
> Happl
Received on Wed Mar 07 2001 - 15:24:13 CET