Re: decode(sth,sth>3,null,sth)-does anybody try ...

From: Richard Kuhler <noone_at_nowhere.com>
Date: Sat, 30 Mar 2002 18:45:40 GMT
Message-ID: <oJnp8.6356$VQ2.3777322_at_twister.socal.rr.com>


uh, either I don't understand the question or you don't understand the decode function ...

select decode(dummy, 'y', null, dummy) from dual;

mariusz wrote:
>
> ok.let's try :
> select decode(dummy,dummy='y',null,dummy) from dual;
> How will you write this?
> sign- not working!!!
> Can you write example?
>
> Użytkownik "mariusz" <on_at_wp.pl> napisał w wiadomości
> news:a7vcqu$hgj$1_at_news.tpi.pl...
> > 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 Sat Mar 30 2002 - 19:45:40 CET

Original text of this message