CASE Statement

--Case Statement
SET SERVEROUTPUT ON
SET VERIFY OFF
DECLARE
  v_user_date DATE := TO_DATE('&user_date','DD-MON-YYYY');
BEGIN
  CASE TO_CHAR(v_user_date,'D')
    WHEN '1' THEN
      dbms_output.put_line('Today is Monday');
    WHEN '2' THEN
      dbms_output.put_line('Today is Tuesday');
    WHEN '3' THEN
      dbms_output.put_line('Today is Wednesday');
    WHEN '4' THEN
      dbms_output.put_line('Today is Thursday');
    WHEN '5' THEN
      dbms_output.put_line('Today is Friday');
    WHEN '6' THEN
      dbms_output.put_line('Today is Saturday');
    ELSE
      dbms_output.put_line('Today is Sunday');
  END CASE;
END;
/
Enter value for user_date: 01-JAN-2011
Today is Saturday
PL/SQL procedure successfully completed.