Re: decode(dummy,dummy='y',null,dummy) from dual
From: Ken Denny <ken_at_kendenny.com>
Date: Thu, 28 Mar 2002 16:27:57 GMT
Message-ID: <Xns91DF754147BA0kendenny_at_65.82.44.7>
Date: Thu, 28 Mar 2002 16:27:57 GMT
Message-ID: <Xns91DF754147BA0kendenny_at_65.82.44.7>
"mariusz" <on_at_wp.pl> wrote in news:a7vfpu$88p$1_at_news.tpi.pl:
> ok.let's try :
> select decode(dummy,dummy='y',null,dummy) from dual;
> How will you write this?
> sing- not working!!!
This should be DECODE(dummy,'y',NULL,dummy). The second parameter is the value to compare to, not a boolean expression.
-- Ken Denny http://www.kendenny.com/ We must respect a man's religion in the same way and to the same extent that we respect his belief that his wife is beautiful and his children are smart.Received on Thu Mar 28 2002 - 17:27:57 CET