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 -> Re: Compare Values in a Decode

Re: Compare Values in a Decode

From: Saad Ahmad <saad.ahmad_at_mchugh.com>
Date: 1998/04/29
Message-ID: <01bd7384$7e1f4de0$2207030a@sahmad-pc.mfa.com>#1/1

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

Original text of this message

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