Oracle Connect生成序列

Author Avatar
Serical 5月 10, 2017
  • 在其它设备中阅读本文章
SELECT TO_CHAR(ADD_MONTHS(TO_DATE('2015-12', 'YYYY-MM'), LEVEL), 'YYYYMM') AS MYDATE
  FROM DUAL
CONNECT BY LEVEL < 17;

MYDATE
------
201601
201602
201603
201604
201605
201606
201607
201608
201609
201610
201611
201612
201701
201702
201703
201704
16 rows selected