This CASE statement is labeled : Case « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. Case

This CASE statement is labeled

  
SQL>
SQL> DECLARE
  2    v_TestVar NUMBER := 1;
  3  BEGIN
  4    <<MyCase>>
  5    CASE v_TestVar
  6      WHEN 1 THEN DBMS_OUTPUT.PUT_LINE('One!');
  7      WHEN 2 THEN DBMS_OUTPUT.PUT_LINE('Two!');
  8      WHEN 3 THEN DBMS_OUTPUT.PUT_LINE('Three!');
  9      WHEN 4 THEN DBMS_OUTPUT.PUT_LINE('Four!');
 10    END CASE MyCase;
 11  END;
 12  /
One!

PL/SQL procedure successfully completed.

SQL>








Related examples in the same category

1.Simple case demo
2.Case conditions
3.Case with else
4.CASE WHEN statement with variable
5.CASE WHEN with constant
6.CASE not found while executing CASE statement
7.CASE WHEN with comparison operator
8.Uses a NUMBER datatype as the selector
9.Output discount rate based on different category