CASE
From: The Magnet <art_at_unsu.com>
Date: Thu, 17 Sep 2009 10:52:39 -0700 (PDT)
Message-ID: <485f556b-55c7-4cd3-a36a-9e0e6eadd0b9_at_m11g2000vbl.googlegroups.com>
Date: Thu, 17 Sep 2009 10:52:39 -0700 (PDT)
Message-ID: <485f556b-55c7-4cd3-a36a-9e0e6eadd0b9_at_m11g2000vbl.googlegroups.com>
This is actually proving harder to find than I originally thought. In PLSDQL, can't I have some CASE statement like this. I want to use an OR in the WHEN clause......
DECLARE
x number := 1;
BEGIN
CASE x
WHEN 1 OR 2 OR 3 THEN
DBMS_OUTPUT.PUT_LINE('YES');
ELSE
DBMS_OUTPUT.PUT_LINE('NO');
END CASE;
END;
/
Received on Thu Sep 17 2009 - 12:52:39 CDT