Re: CASE statement implemented?

From: Wayne or Donna Weiselogel <waynerw_at_flash.net>
Date: Tue, 23 Feb 1999 06:09:33 GMT
Message-ID: <xCrA2.946$7p1.1486@news.flash.net>

Try the following, it is used extensively in Oracle procedures.

IF....THEN...;
ELSIF.....THEN....;
ELSIF.....THEN....;
ELSE....THEN....;

END IF;
Stefan Sandow wrote in message <7arvls$3q5$1_at_black.news.nacamar.net>...
>Hi there,
>I desparate need to know if there is a CASE statement implemented in Oracle
>8, where you can evaluate expressions like the following:
>
>CASE
>WHEN
> (a>b)
> then 'greater'
> else
> 'not greater'
>end
>I know that there is a DECODE, BUT..
>It can't do things like:
>DECODE((a>b), True, 'greater', 'not greater')
>
>Thanks for any usefull suggestion!
>Stefan
>
>
Received on Tue Feb 23 1999 - 00:09:33 CST