数值1到10的求法:
SELECT 1 + ROWNUM - 1 FROM DUAL
CONNECT BY ROWNUM < 10 -1 +2;
日期20160101到20180630的求法:
SELECT TO_NUMBER(TO_CHAR(TO_DATE(20160101,'YYYYMMDD') + ROWNUM - 1,'YYYYMMDD')) DT
FROM DUAL
CONNECT BY ROWNUM < TO_DATE(20180601,'YYYYMMDD') - TO_DATE(20160101,'YYYYMMDD') + 2;