Re: Qurey question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 16 Oct 2001 21:43:30 +0200
Message-ID: <tsp3nhporr1o1f@corp.supernews.com>

"Jack Simmions" <laclac01_at_yahoo.com> wrote in message news:3bcc7e9d_2_at_corp-news.newsgroups.com...
> in the order of 10, 30, 20 I wish them to appear.
>
> "Alexei VORONOV" <alexei_voronov_at_yahoo.com> wrote in message
> news:9qhrov$aa$1_at_wanadoo.fr...
> >
> > "Jack Simmions" <laclac01_at_yahoo.com> a écrit dans le message news:
> > 3bcc6406_3_at_corp-news.newsgroups.com...
> > > In a query if I want to order my departments by a department number in
> > order
> > > of 10, 30, 20 how would I go about attempting this? Can this be done
> with
> > ^^^^^^^^^^ In what order?
> >
> >
>
>

order by decode(10,1,30,2,20,3)

If the number of values becomes larger this is going to be a nightmare

Hth,

Sybrand Bakker
Senior Oracle DBA Received on Tue Oct 16 2001 - 14:43:30 CDT