Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Compare Values in a Decode
decode ( sign(field), -1,...,... )
pjklimt_at_mailexcite.com wrote in article
<6i7gcj$pcg$1_at_nnrp1.dejanews.com>...
> I want to compare a value in a Decode to see if it is greater then
another
> value. Depending on the outcome I want to post a different message. for
> example in code I would write "IF (1 > 0){'True'}else{'False'}". I tried
> DECODE(FIELD > 0, TRUE, 'True', 'False) to no avail. Thanks in Advance.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
Received on Wed Apr 29 1998 - 00:00:00 CDT