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

In article <a7vfkk$78n$1_at_news.tpi.pl>, "mariusz" says...
>
>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?
>

Dan said "case", not "decode"

ops$tkyte_at_ORA817DEV.US.ORACLE.COM> select CASE when dummy='Y' then null

  2                                            else dummy
  3                                       END
  4                                  from dual;

C
-
X

>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
>>
>
>

--
Thomas Kyte (tkyte_at_us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp