Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Modify the order sequence

Re: Modify the order sequence

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 07 Sep 2005 08:40:19 -0700
Message-ID: <1126107568.309693@yasure>


kevin.davis_at_kevincdavis.net wrote:
> Hello,
>
> 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 ?
>
> Thanks!
>
> Kevin

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.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Sep 07 2005 - 10:40:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US