Re: decode(sth,sth>3,null,sth)-does anybody try ...
From: mariusz <on_at_wp.pl>
Date: Thu, 28 Mar 2002 17:18:06 -0000
Message-ID: <a7vfkk$78n$1_at_news.tpi.pl>
Date: Thu, 28 Mar 2002 17:18:06 -0000
Message-ID: <a7vfkk$78n$1_at_news.tpi.pl>
ok.let's try :
[Quoted] select decode(dummy,dummy='y',null,dummy) from dual;
How will you write this?
sign- not working!!!
Can you write example?
[Quoted] Uzytkownik "damorgan" <damorgan_at_exesolutions.com> napisal w wiadomosci
news:3CA33FC6.123BEDC5_at_exesolutions.com...
> Yes. The function that works like this is CASE. In 8i you can use it at
> the SQL*Plus prompt, in views, and through Native Dynamic SQL. In 9i you
> can use it anywhere.
>
> Daniel Morgan
>
>
>
> mariusz wrote:
>
> > Hi,
> > decode(sth,sth>3,null,sth)-does anybody try anything like this?
> > Is there any others easy whay to code like that?
> > Thanks
>
Received on Thu Mar 28 2002 - 18:18:06 CET