Decode function

From: Unmesh <unmeshl_at_aol.com>
Date: Mon, 25 Oct 1999 12:01:27 -0400
Message-ID: <38147ED7.60F1F559_at_aol.com>

[Quoted] [Quoted] What if the decode fuction need to be used with list of values using between
operator?
like say

[Quoted] 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 - 18:01:27 CEST