ORACLE obtains the month list between a certain period of time.

ORACLE obtains the month list between a certain period of time to obtain the month list between a certain period of time (the example returns the month list between and) www.2cto.com SELECT TO_CHAR (ADD_MONTHS (TO_DATE ('2017-03 ', 'yyyy-mm'), ROWNUM-1), 'yyyy-mm') DAY_ID from dual connect by rownum <= months_between (to_date ('2017-03 ', 'yyyy-mm'), to_date ('2017-03', 'yyyy-mm ')) + 1 get the date list for a certain period of time (the example returns the date list between and) SELECT TO_CHAR (TO_DATE ('2017-04-1 ', 'yyyy-MM-DD') + ROWNUM-1, 'yyyy-MM-DD ') DAY_ID from dual connect by rownum <= trunc (to_date ('2017-05-23', 'yyyy-mm-dd ') -to_date ('2017-04-1 ', 'yyyy-mm-dd') + 1