获取日期列表:
SELECT TO_CHAR(TO_DATE('2014-10-01', 'yyyy-MM-dd') + ROWNUM - 1, 'yyyyMMdd') as daylistSELECT TO_CHAR(TO_DATE('2014-10-
获取日期列表:
SELECT TO_CHAR(TO_DATE('2014-10-01', 'yyyy-MM-dd') + ROWNUM - 1, 'yyyyMMdd') as daylistSELECT TO_CHAR(TO_DATE('2014-10-