Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: case short circuits?
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