Re: Decode function to Oracle 7

Am Thu, 14 Oct 2004 15:02:42 +0200 schrieb @rennes <l.sass_at_omp-transport.com>:

> I have that
>
> select
>
> decode(myNumberField > 0,
> True, 'toto',
> False, 'titi') MYRESULT
>
> from RogerTable
>
> Oracle 7 say "missing right parentheses" in the > caractere.
>
> How could i make this test in oracle 7

Try:

decode(sign(myNumberField),

• case > 0 1, 'toto',
• default value 'titi') MYRESULT Frank

-- 
Crisis? What Crisis?
----------------------------------------------------
f_r_a_n_k_a_t_k_o_n_a_d_d_o_t_n_e_t