Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: No support for CASE keyword??
On Wed, 24 Jun 1998 19:35:16 +0800, "johnnie (isg cooper)" <johnnie_at_prima.netfront.net> wrote:
>It seems that DECODE does not support expression such as >, >=, <, <=,
>between. Am I right?
You're right. However you can use other functions (like SIGN, LEAST, GREATEST, ......) inside decode expression to mimic just about any comparison operator.
Regards,
Jurij Modic Republic of Slovenia jurij.modic_at_mf.sigov.mail.si Ministry of Finance ============================================================The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Jun 24 1998 - 00:00:00 CDT