Re: case expression to decode function

From: nobody <nobody_at_nowhere.com>
Date: Sat, 12 Apr 2003 02:51:57 GMT
Message-ID: <hbLla.6930$BQi.2131@news04.bloor.is.net.cable.rogers.com>

select decode(points,1,'foo',decode(sign(points),0,'hoo',1,'boo',-1,'hoo')) from X

"db dude" <db_guy_2002_at_yahoo.com> wrote in message news:f4a8da28.0304111758.1d29ecf9_at_posting.google.com...
> SELECT CASE WHEN a > 1 THEN 'boo' WHEN a < 1 then 'hoo' ELSE 'foo' END
> from X;
>
> Oracle 8 does not support case expressions. Can some one give me an
> oracle 8 select query that does the same thing as the select query
> above.
>
> Thanks
Received on Fri Apr 11 2003 - 21:51:57 CDT