SELECT (TO_DATE('20140213', 'YYYYMMDD') + LEVEL - 1) CALENDAR_DAY
FROM DUAL
CONNECT BY LEVEL <= TO_DATE('20140313', 'YYYYMMDD') -
TO_DATE('20140213', 'YYYYMMDD') + 1
FROM DUAL
CONNECT BY LEVEL <= TO_DATE('20140313', 'YYYYMMDD') -
TO_DATE('20140213', 'YYYYMMDD') + 1