SELECT SUBSTR(A.A2, 1, 4)"년",
SUBSTR(A.A2, 5, 2)"월",
SUBSTR(A.A2,-2, 2)"일",
DECODE(A.A1, '1', '일', '2', '월',
'3', '화', '4', '수',
'5', '목', '6', '금',
'7', '토')"요일"
FROM ( SELECT TO_CHAR(TO_DATE('200503'||TO_CHAR(ROWNUM),'YYYYMMDD'), 'd') AS A1,
TO_CHAR(TO_DATE('200503'||TO_CHAR(ROWNUM),'YYYYMMDD'), 'YYYYMMDD') AS A2
FROM user_objects
WHERE ROWNUM <= 31
AND ROWNUM > 0
AND TO_CHAR(LAST_DAY(TO_DATE('200503' || '01', 'YYYYMMDD')), 'DD')>= LTRIM(TO_CHAR(ROWNUM, '00'))
)A