SELECT DateRange
FROM
(
select to_date('15 10 2007','DD MM YYYY')-1 + level as DateRange
from dual
where (to_date('15 10 2007','DD MM YYYY')-1+level) <=
last_day(to_date('15 10 2007','DD MM YYYY'))
connect by level<=5
)
ORDER BY DateRange
