Re: DECODE on numeric field

A copy of this was sent to Dipen Kotecha <dkotecha_at_ford.invalid> (if that email address didn't require changing) On Tue, 17 Aug 1999 11:56:55 +0200, you wrote:

>Is it possible to use DECODE with a numeric field. For example :
>
>DECODE (amount, <0, 'NEGATIVE', 0, 'ZERO', 'POSITIVE')
>

decode( sign(amount), -1, 'negative', 0, 'zero', 'positive' )

>Any help would be appreciated.
>
>Thanks in advance,
>
>Dipen

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Aug 17 1999 - 06:49:17 CDT