Re: I want to use arithmetic operator ">" in function "Decode"
From: Mark Styles <news_at_lambic.co.uk>
Date: Tue, 09 Oct 2001 14:41:45 GMT
Message-ID: <f136stggv0ipudn34tpm3equ3qk46sccsj_at_4ax.com>
Date: Tue, 09 Oct 2001 14:41:45 GMT
Message-ID: <f136stggv0ipudn34tpm3equ3qk46sccsj_at_4ax.com>
On 9 Oct 2001 07:05:55 -0700, bajy_at_intizen.com (Ryan Park) wrote:
>SELECT DECODE (10 > 1, 1, 'T', 'F' ) FROM DUAL
>All these makes error "ORA-00907:missing right parenthesis.".
>
>I wonder why these are not allowed under oracle 8.0.
SELECT DECODE(GREATEST(10,1),10,'T','F') FROM dual; Received on Tue Oct 09 2001 - 16:41:45 CEST