Re: decode(sth,sth>3,null,sth)-does anybody try ...
From: stinky <_at_stinky_at_zdnetmail.com>
Date: Thu, 28 Mar 2002 19:09:31 -0500
Message-ID: <wuOo8.25654$x51.556504_at_news.webusenet.com>
Date: Thu, 28 Mar 2002 19:09:31 -0500
Message-ID: <wuOo8.25654$x51.556504_at_news.webusenet.com>
damorgan wrote:
> 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.
What other areas can you use it in 9i? I love the CASE expression. It is a piece of wonder code.
>
>
> 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 Fri Mar 29 2002 - 01:09:31 CET