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>
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