SQL> SELECT TO_CHAR(SYSDATE, 'DAY') AS DAY
     2        FROM DUAL;

   DAY
   --------
   THURSDAY