Re: Correct syntax for 'CASE WHEN' clause

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 21 Mar 2000 18:15:17 -0000
Message-ID: <953663248.4199.0.nnrp-10.9e984b29@news.demon.co.uk>

It is actually part of the SQL 92 standard, and it finally appears in Oracle in 8.1.6.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Stephan Born wrote in message <38D7910A.26675CDA_at_beusen.de>...
>
>
>select decode (contract_coupon_type, 'm', 'Manufacturer', 'Retailer')
>from contract_t;
>
>As far as I know CASE WHEN is not Standard-SQL....on which database does
this
>stament run?
>
Received on Tue Mar 21 2000 - 12:15:17 CST