Oracle CASE
From: Mtek <mtek_at_mtekusa.com>
Date: Mon, 23 Feb 2009 10:30:45 -0800 (PST)
Message-ID: <0d444206-9e41-4867-a3e9-459e0207ea14_at_l1g2000yqj.googlegroups.com>
Date: Mon, 23 Feb 2009 10:30:45 -0800 (PST)
Message-ID: <0d444206-9e41-4867-a3e9-459e0207ea14_at_l1g2000yqj.googlegroups.com>
[Quoted] 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 typeReceived on Mon Feb 23 2009 - 19:30:45 CET