Can you have multiple conditions in the WHEN clause of a CASE
statement?


CASE v_subproduct_id
WHEN 197 OR 95 THEN
..
..
..

I get some weird stuff:

LINE/COL ERROR
--------
-----------------------------------------------------------------
45/4 PL/SQL: Statement ignored
46/9 PLS-00382: expression is of wrong type

On 23 Febr., 20:30, Mtek <m... (AT) mtekusa (DOT) com> wrote:

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

On Feb 23, 3:35*pm, Gints Plivna <gints.pli... (AT) gmail (DOT) com> wrote:
Well, both the 197 & 95 will execute the same code, there is no reason
to code them separately......so, I guess #2 is the way to go. I just
hate having to re-state the variable I am testing over and over again
in each condition......

On Feb 24, 8:07*am, Mtek <m... (AT) mtekusa (DOT) com> wrote:
Is there nothing in Oracle about which you won't complain?


David Fitzjarrell

Mtek wrote:
Then I would (and so should you) tend to question your database design
as to why you have to do this... It may be perfectly valid, all I am
stating is that I would have to reevaluate the design....