Re: Decode function
From: Stephan Born <stephan.born_at_beusen.de>
Date: Tue, 26 Oct 1999 10:47:57 +0200
Message-ID: <38156ABD.953BF728_at_beusen.de>
Date: Tue, 26 Oct 1999 10:47:57 +0200
Message-ID: <38156ABD.953BF728_at_beusen.de>
> What if the decode fuction need to be used with list of values using
> between
> operator?
> like say
> select ...
> from ...
> where ...
> order by decode(ITF.ITEM_TYPE, (between 60 and 64) , 0, (between 30 and
> 32) , 1, 45,
> 2, 90, 3, 46, 4, 5);
>
> Any feedback is appreciated..
>
Try to use a table for mapping your values to 'order by'-values. I wrote you that in Thread 'SQL problem with Order by'.
Regards, Stephan
-- --------------------------------------------------------------- Dipl.-Inf. (FH) Stephan Born | beusen Consulting GmbH fon: +49 30 549932-17 | Landsberger Allee 392 fax: +49 30 549932-29 | 12681 Berlin mailto:stephan.born_at_beusen.de | Germany ---------------------------------------------------------------Received on Tue Oct 26 1999 - 10:47:57 CEST