Great, thanks
"Frank Piron" <empty_at_zero.nil> a écrit dans le message de news:
opsfu26ty0m0et4w_at_news.online.de...
> 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
Received on Thu Oct 14 2004 - 09:32:14 CDT
