Day of the week, Day of the week for previous day in Oracle

select to_char(to_date('15-09-2010','dd-MM-yyyy'),'D') from dual; -- day of week for a date

select to_char(to_date('15-09-2010','dd-MM-yyyy')-1,'D') from dual; -- day of week for a date before