Oracle ERP 1个月有几个周一并求周一对应的日期

Oracle ERP 1个月有几个周一并求周一对应的日期

Oracle ERP 1个月有几个周一并求周一对应的日期

SELECT DECODE(TO_CHAR(TO_DATE('20111130','YYYYMMDD') - LEVEL-1,'D')
                      ,'2'
                      ,TO_CHAR(TO_DATE('20111130','YYYYMMDD') - LEVEL-1))  AS Monday
   FROM DUAL
   where DECODE(TO_CHAR(TO_DATE('20111130','YYYYMMDD') - LEVEL-1,'D')
        ,'2'
        ,TO_CHAR(TO_DATE('20111130','YYYYMMDD') - LEVEL-1)) is not null
CONNECT BY LEVEL < TO_DATE('20111130','YYYYMMDD') - TO_DATE('20111101','YYYYMMDD')
order by DECODE(TO_CHAR(TO_DATE('20111130','YYYYMMDD') - LEVEL-1,'D')
               ,'2'
               ,TO_CHAR(TO_DATE('20111130','YYYYMMDD') - LEVEL-1))

--刘轶鹤