Re: Modify the order sequence

From: Walt <walt_askier_at_SHOESyahoo.com>
Date: Wed, 07 Sep 2005 12:06:33 -0400
Message-ID: <deETe.568$De1.301@news.itd.umich.edu>

DA Morgan wrote:
> kevin.davis_at_kevincdavis.net wrote:

>> I have a question with regards to the order seqeunce.. I have data that
>> is displayed by id numbers. The id numbers are 1,2,3,4,5,6,8,9,10 .. Is
>> there a sql statement that will allow the id to sort like this:
>> 1,2,8,3,4,5,6,9,10 ?

>
> No. But it can be done if you are capable of writing a logical rule
> that defines the order. From what I can see, above, your order is
> completely arbitrary and meaningless.

If that's the case he could just use the dbms_random package.

//Walt Received on Wed Sep 07 2005 - 11:06:33 CDT