Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> DECODE on numeric field

DECODE on numeric field

From: Dipen Kotecha <dkotecha_at_ford.invalid>
Date: Tue, 17 Aug 1999 11:56:55 +0200
Message-ID: <37B931E7.9C0019F3@ford.invalid>


Is it possible to use DECODE with a numeric field. For example :

DECODE (amount, <0, 'NEGATIVE', 0, 'ZERO', 'POSITIVE')

Any help would be appreciated.

Thanks in advance,

Dipen Received on Tue Aug 17 1999 - 04:56:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US