Re: SQL Question
From: Matt B. <mcb_at_ds.znet.com>
Date: Fri, 8 Dec 2000 16:25:37 -0800
Message-ID: <t32utg8cvkp8d9_at_corp.supernews.com>
Date: Fri, 8 Dec 2000 16:25:37 -0800
Message-ID: <t32utg8cvkp8d9_at_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 Sat Dec 09 2000 - 01:25:37 CET