计算上一周: between to_char(sysdate - (to_char(sysdate,'D')-1)-6,'yyyy-mm-dd') and to_char(sysdate - (to_char(sysdate,'D')-1),'yyyy-mm-dd')