SELECT to_date('01.01.2014', 'dd.mm.rrrr') + LEVEL - 1, LEVEL FROM DUAL CONNECT BY LEVEL <= to_date('15.01.2014', 'dd.mm.rrrr') + 1 - to_date('01.01.2014', 'dd.mm.rrrr');