Mega Code Archive

 

Categories / Oracle PLSQL / PL SQL

 

CASE WHEN with constant

SQL> SQL> SQL> DECLARE   2    v_TestVar NUMBER := 2;   3  BEGIN   4    CASE v_TestVar   5      WHEN 2 THEN DBMS_OUTPUT.PUT_LINE('Two!');   6      WHEN 3 THEN DBMS_OUTPUT.PUT_LINE('Three!');   7      WHEN 4 THEN DBMS_OUTPUT.PUT_LINE('Four!');   8    END CASE;   9  END;  10  / Two! PL/SQL procedure successfully completed. SQL> SQL>