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: Walt <walt_askier_at_SHOESyahoo.com>
Date: Wed, 07 Sep 2005 11:19:51 -0400
Message-ID: <qyDTe.567$De1.542@news.itd.umich.edu>


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 ?

Yes. The ORDER BY clause is very flexible and you can do just about whatever you want. But I have no idea what you're trying to do.

//Walt Received on Wed Sep 07 2005 - 10:19:51 CDT

Original text of this message

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