[Oracle] 두 일자 사이(기간) Month 가져오기

두 일자 사이(기간) Month 가져오기

WITH T AS ( SELECT '20181201' START_DATE,'2019-12-13' END_DATE FROM DUAL ) SELECT TO_CHAR(ADD_MONTHS(TRUNC(TO_DATE(START_DATE),'MM'),LEVEL - 1),'YYYYMM') MONTH FROM T CONNECT BY TRUNC(TO_DATE(END_DATE),'MM') >= ADD_MONTHS(TRUNC(TO_DATE(START_DATE),'MM'),LEVEL - 1);

<Result>

MONTH 

------

201812

201901

201902

201903

201904

201905

201906

201907

201908

201909

201910

201911

201912