--罗列一个星期的日期
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;