select ('2015-02-' || daynum) DAYNUM1
from (select to_char(to_date('2015-02', 'yyyy-mm') + (rownum - 1),
'dd') DAYNUM
from dual
connect by rownum <= to_number(to_char(last_day(to_date('2015-02',
'yyyy-mm')),
'dd')))
from (select to_char(to_date('2015-02', 'yyyy-mm') + (rownum - 1),
'dd') DAYNUM
from dual
connect by rownum <= to_number(to_char(last_day(to_date('2015-02',
'yyyy-mm')),
'dd')))