Re: Oracle CASE

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Mon, 23 Feb 2009 13:35:07 -0800 (PST)
Message-ID: <01e6cf9a-1131-4518-99a8-d7f188808818_at_j39g2000yqn.googlegroups.com>


[Quoted] On 23 Febr., 20:30, Mtek <m..._at_mtekusa.com> wrote:
> Can you have multiple conditions in the WHEN clause of a CASE
> statement?
>
>    CASE v_subproduct_id
>    WHEN 197 OR 95 THEN
either

case v
when 197 then 'x'
when 95 then 'x'
end

Or
case when v = 197 or v = 95 then 'x'
end

Gints Plivna
http://www.gplivna.eu Received on Mon Feb 23 2009 - 22:35:07 CET

Original text of this message