Re: Decode function
Date: Mon, 25 Oct 1999 20:19:58 GMT
Message-ID: <OX2R3.282$kvj.187800576_at_newsa.telia.net>
[Quoted] I dont think you can do that, without using one value for each value in of ITEM_TYPE. I am trying to work something out and map values between 60 to 64 on 0 (not inside) and 1 (inside) but I cant think of any. Someone else might do that...if one succed it would be a great number of DECODES...
You can not solve it using GREATEST and LOWEST? Maybe those are not allowed in WHERE-clauses.
Lars
Unmesh skrev i meddelandet <38147ED7.60F1F559_at_aol.com>...
>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..
>
>Thanks
>Unmesh
>
>
>
Received on Mon Oct 25 1999 - 22:19:58 CEST