Re: Case expression
From: Raj Kolluri <rkolluri_at_hotmail.com>
Date: 1998/09/22
Message-ID: <360825F3.84B0BE71_at_hotmail.com>#1/1
Date: 1998/09/22
Message-ID: <360825F3.84B0BE71_at_hotmail.com>#1/1
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 CEST