Oracleで一ヶ月分のレコード作成
SELECT TO_CHAR(START_DATE + (ROWNUM - 1), 'YYYY/MM/DD') AS MONTH_DAY, TO_CHAR(START_DATE + (ROWNUM - 1), 'DY') AS WEEK_DAY FROM (SELECT TO_DATE('2013/11/01', 'YYYY/MM/DD') AS START_DATE, TO_NUMBER(TO_CHAR(LAST_DAY(TO_DATE('2013/11/01', 'YYYY/MM/DD')), 'DD')) AS DAYS FROM DUAL ), ALL_CATALOG WHERE ROWNUM <= DAYS