Re: Correct syntax for 'CASE WHEN' clause

Bob schrieb:

> I'm getting the following error trying to use a 'CASE WHEN' expression in a
> SELECT statement.
>
> SQL> select case when contract_coupon_type = 'm'
> 2 then 'Manufacturer'
> 3 else 'Retailer'
> 4 end as x
> 5 from contract_t;
> select case when contract_coupon_type = 'm'

select decode (contract_coupon_type, 'm', 'Manufacturer', 'Retailer') from contract_t;

>
> I can't find any reference to 'CASE WHEN' in the online Oracle docs.
> Does Oracle support this? If not, how do I implement equivalent
> functionality? If so, what am I doing wrong?

As far as I know CASE WHEN is not Standard-SQL....on which database does this stament run?

Oracle does not support it...use decode instead.

Regards, Stephan

--

Dipl.-Inf. (FH) Stephan Born   | beusen Consulting GmbH
fon: +49 30 549932-0           | Landsberger Allee 392
fax: +49 30 549932-21          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------
       PGP-Key verfügbar       |      PGP-Key available
---------------------------------------------------------------