select to_char(to_date(m.dates),'yyyy-mm-dd Day') as ss
from(SELECT TRUNC(TO_DATE('2015-04-28', 'yyyy-MM-dd')) + ROWNUM - 1 AS DATES
FROM ALL_OBJECTS
WHERE TRUNC(TO_DATE('2015-04-28', 'yyyy-MM-dd')) + ROWNUM - 1 <=
TRUNC(TO_DATE('2015-05-19', 'yyyy-MM-dd'))) m