SELECT MAX(DECODE(LV,0,DT2)) "일" , MAX(DECODE(LV,1,DT2)) "월" , MAX(DECODE(LV,2,DT2)) "화" , MAX(DECODE(LV,3,DT2)) "수" , MAX(DECODE(LV,4,DT2)) "목" , MAX(DECODE(LV,5,DT2)) "금" , MAX(DECODE(LV,6,DT2)) "토" FROM (SELECT LV , A.DT + B.LV AS DT2 FROM (SELECT NEXT_DAY(TO_DATE('20151202','RRRRMMDD'), 1) - 7 DT FROM DUAL ) A ,(SELECT LEVEL -1 LV FROM DUAL CONNECT BY LEVEL <= 7 ) B )