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>


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

Original text of this message