Re: Returning Rows in Random Order
From: Happl Oberlin <happl_at_mail.com>
Date: Wed, 07 Mar 2001 14:17:35 +0100
Message-ID: <happl-F778E4.14173507032001_at_news.fu-berlin.de>
Date: Wed, 07 Mar 2001 14:17:35 +0100
Message-ID: <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.
[Quoted] [Quoted] If there is no ORDER BY or GROUP BY in the query and [Quoted] 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 - 14:17:35 CET