Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: case expression to decode function

Re: case expression to decode function

From: nobody <nobody_at_nowhere.com>
Date: Sat, 12 Apr 2003 03:07:06 GMT
Message-ID: <upLla.7041$BQi.3665@news04.bloor.is.net.cable.rogers.com> 





or just subtract 1 and then use sign.



"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 - 22:07:06 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US