SELECT TO_CHAR(TO_DATE('20140101', 'YYYYMMDD') + LEVEL - 1, 'YYYY-MM-DD') AS MYDATE
FROM DUAL CONNECT BY LEVEL <= (TO_DATE('20141231', 'YYYYMMDD') - TO_DATE('20140101', 'YYYYMMDD') + 1);
SELECT TO_CHAR(TO_DATE('20140101', 'YYYYMMDD') + LEVEL - 1, 'YYYY-MM-DD') AS MYDATE
FROM DUAL CONNECT BY LEVEL <= (TO_DATE('20141231', 'YYYYMMDD') - TO_DATE('20140101', 'YYYYMMDD') + 1);