Oracle - 월 달력 SQL
기본 명령들만 사용해서 년,월 (예:201512) 을 입력받고 해당 년월의 달력 형태로 조회하는 SQL SELECT WEEK_NUM , MAX(DECODE(DAY_NUM, 1, MONTH_DAY)) AS DAY1 , MAX(DECODE(DAY_NUM, 2, MONTH_DAY)) AS DAY2 , MAX(DECODE(DAY_NUM, 3, MONTH_DAY)) AS DAY3 , MAX(DECODE(DAY_NUM, 4, MONTH_DAY)) AS DAY4 , MAX(DECODE(DAY_NUM, 5, MONTH_DAY)) AS DAY5 , MAX(DECODE(DAY_NUM, 6, MONTH_DAY)) AS DAY6 , MAX(DECODE(DAY_NUM, 7, MONTH_DAY)) AS DAY7 FROM ( SE..
2015.12.03