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

Home -> Community -> Usenet -> c.d.o.server -> Re: case short circuits?

Re: case short circuits?

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 21 Jun 2005 07:40:18 -0700
Message-ID: <1119364825.54174@yasure>


rogergorden_at_gmail.com wrote:
> CASE is also better for the reasons stated above and for the fact that
> you can use CASE for inequality tests >, <, etc. where as with DECODE
> you cannot.
>
> Regards,
>
> Roger Gorden

At least not directly. Using SIGN with DECODE does allow for it in a limited scope.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Jun 21 2005 - 09:40:18 CDT

Original text of this message

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