oracle查询截至到当前日期月份所在年份的所有月份

下面通过一个查询语句给大家介绍oracle查询截至到当前日期月份所在年份的所有月份，具体代码如下所示：

SELECT to_number(TO_CHAR(add_months(trunc(sysdate, 'yy'), ROWNUM - 1), 'MM')) as month
 FROM DUAL
CONNECT BY ROWNUM <=
 (select months_between(trunc(sysdate, 'mm'), trunc(sysdate, 'yy')) + 1
 from dual);