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 -> case expression to decode function

case expression to decode function

From: db dude <db_guy_2002_at_yahoo.com>
Date: 11 Apr 2003 18:58:02 -0700
Message-ID: <f4a8da28.0304111758.1d29ecf9@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 - 20:58:02 CDT

Original text of this message

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