select to_char(to_date('201702','yyyymm')+(rownum-1),'dd') DAY_ID
from dual
connect by rownum<=to_number(to_char(last_day(to_date('201702','yyyymm')),'dd'))
select to_char(to_date('201702','yyyymm')+(rownum-1),'dd') DAY_ID
from dual
connect by rownum<=to_number(to_char(last_day(to_date('201702','yyyymm')),'dd'))