orcal输入开始时间结束时间获取年月
  SELECT DISTINCT(TO_CHAR(T.ROWDATE, 'yyyymm')) YYYYMM
    FROM (
         SELECT ROWNUM, TO_DATE('201805', 'yyyymm') + ROWNUM - 1 ROWDATE
           FROM DUAL CONNECT BY ROWNUM < TO_DATE('201901', 'yyyymm') - TO_DATE('201805', 'yyyymm') + 2) T
   ORDER BY YYYYMM

 
                
            
         
         浙公网安备 33010602011771号
浙公网安备 33010602011771号