SELECT YYMM || LPAD(ROWNUM, 2, '0') TO_DAY FROM DUAL CROSS JOIN ( SELECT '2014' AS YYMM FROM DUAL)B CONNECT BY LEVEL<=TO_NUMBER(12);