Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> case expression to decode function
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