sql 取当月 所有日期

SELECT to_date(to_char(TO_DATE('2017-06-01' ,'yyyy-mm-dd') + LEVEL - 1 , 'yyyy-mm-dd'),'yyyy-MM-dd') dt
  FROM DUAL CONNECT BY LEVEL <= to_number(to_char(LAST_DAY(TO_DATE('2017-06-01' ,'yyyy-mm-dd')),'dd'))