Re: SQL Question

From: Matt B. <mcb_at_ds.znet.com>
Date: Fri, 8 Dec 2000 16:25:37 -0800
Message-ID: <t32utg8cvkp8d9@corp.supernews.com>

"Zbigniew Sliwa" <zibi_at_at_yahoo.com> wrote in message news:3A30BBD8.B12268A7_at_yahoo.com...
> Adrian,
>
> I don't know your DB version.
> Starting from 8i you can use CASE function.

From 8.1.6 (IIRC), to be specific. When you long into SQL*Plus it usually will tell you what the version of the DB is.

-Matt

> Prior to 8i you can do it using decode function (as below).
Received on Fri Dec 08 2000 - 18:25:37 CST