Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Case expression
The case expression for Oracle is Decode.
The syntax (approx) is Decode(column, if column = value , then value is , elsif column = value, then value is , else value is )
HTH
Raj
Craig Levisay wrote:
> Would anyone know what the Oracle v8.0.4 equivalent of the CASE expression
> might be?
>
> I've used case expressions within select statements on MS SQL Server,
> Informix and DB2 so I know its not a rarely used expression.
>
> TIA
> Craig Levisay
> craig_levisay_at_sabre.com
Received on Tue Sep 22 1998 - 00:00:00 CDT