Re: Case Statement

From: <corvax_kg_at_my-deja.com>
Date: Sat, 04 Nov 2000 08:31:56 GMT
Message-ID: <8u0hhs$v1p$1@nnrp1.deja.com>

No. CASE statement is not supported in Oracle8. This statement will be supported in Oracle9i. :) Wait for Oracle9i full release.

In article <OnFYrRfRAHA.369_at_cpmsnbbsa07>, "Mason Liu" <masonliu_at_msn.com> wrote:
> Does Oracle8 support the case statement in SELECT.
>
> For example:
>
> SELECT (CASE col_a WHEN 1 THEN 'ONE' WHEN 2 THEN 'TWO' ELSE 'UNKNOWN'
END)
> FROM table...
>
> I know decode() can accomplish this, but I like to know this for
migration
> reasons.
>
> Thanks,
>
> Mason Liu
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Nov 04 2000 - 02:31:56 CST