Re: decode(sth,sth>3,null,sth)-does anybody try ...
From: mariusz <on_at_wp.pl>
Date: Thu, 28 Mar 2002 17:15:49 -0000
Message-ID: <a7vfgc$6co$1_at_news.tpi.pl>
Date: Thu, 28 Mar 2002 17:15:49 -0000
Message-ID: <a7vfgc$6co$1_at_news.tpi.pl>
ok.let's try :
[Quoted] select decode(dummy,dummy='y',null,dummy) from dual;
How will you write this?
sing- not working!!!
Użytkownik "LokalST" <stbest001_at_hotmail.com> napisał w wiadomości
news:a7vdlg$kmb$1_at_sunce.iskon.hr...
>
> "mariusz" <on_at_wp.pl> wrote in message 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?
>
> Maybe this?
> If sth> 3 then sign (sth-1) will be 1 and You get null,else,You get sth.
> Decode(sign(sth-3),1,null,sth)
> Hope this help.
>
>
Received on Thu Mar 28 2002 - 18:15:49 CET