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