关于日期和星期

--罗列一个星期的日期

 select to_char(everyday, 'yyyy-mm-dd') everyday
  from (select trunc(sysdate,'WW') + 1 + level - 1 as everyDay
          from dual
        connect by level <= (select trunc(sysdate,'WW') + 7 from dual) -
                   (select trunc(sysdate,'WW') + 1 from dual) + 1);  

--当前周的星期一和星期日

select trunc(sysdate,'WW')+1  from dual;

select trunc(sysdate,'WW')+7  from dual;