Yes, use the to_char function in this way:

SQL> select to_char(sysdate, 'day') from dual;

the answer will be :

TO_CHAR(SYSDATE,'DAY')
---------------------------------------------------
saturday