Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Modify the order sequence
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