TO_CHAR 옵션.

SELECT TO_DATE('200803'||TO_CHAR(rownum),'YYYYMMDD') AS sbs,
  to_char(TO_DATE('200803'||TO_CHAR(rownum),'YYYYMMDD'),'DY') AS sbs1,
  to_char(TO_DATE('200803'||TO_CHAR(rownum),'YYYYMMDD'),'D') AS sbs2
FROM all_objects
WHERE rownum <= 31
AND rownum > 0;