| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> DECODE on numeric field
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
![]() |
![]() |