Re: Random Order BY

[Quoted] "Josef Huber" <josef.huber_at_ennstal.at> wrote:

>Hello,
>
>I have often sql statements with the same data and want sort the
>data in a different order.
>Is there a way to do so a random sort ?
>
>
>Ciao,
>Joe
>
>

The order of the results is determined by the 'ORDER BY' clause, so using a different one will alter the order ( this may seem obvious, but you asked)

To get a 'random' order, you could use the 'Select .....from.....' clause with NO order by specification and the results will be in unordered form ( Oracle stores and retrieves in a random-like manner, if no instructions are given )

To reply please remove the 'nospam' part of the address Received on Tue Aug 18 1998 - 00:00:00 CEST