[DATABASE/ORACLE] 해당 월 달력 조회하기

■ 해당 월 달력을 조회하는 방법을 보여준다.

 

▶ 예제 코드 (SQL)

SELECT
    MIN(CASE WHEN TO_CHAR(DAYS, 'd') = 1 THEN DAYS END) AS 일
   ,MIN(CASE WHEN TO_CHAR(DAYS, 'd') = 2 THEN DAYS END) AS 월
   ,MIN(CASE WHEN TO_CHAR(DAYS, 'd') = 3 THEN DAYS END) AS 화
   ,MIN(CASE WHEN TO_CHAR(DAYS, 'd') = 4 THEN DAYS END) AS 수
   ,MIN(CASE WHEN TO_CHAR(DAYS, 'd') = 5 THEN DAYS END) AS 목
   ,MIN(CASE WHEN TO_CHAR(DAYS, 'd') = 6 THEN DAYS END) AS 금
   ,MIN(CASE WHEN TO_CHAR(DAYS, 'd') = 7 THEN DAYS END) AS 토
FROM
(
    SELECT
        BASE_MONTH + LEVEL - 1                                                                        AS DAYS
       ,(TRUNC(BASE_MONTH + LEVEL - 1, 'd') - TRUNC(TRUNC(BASE_MONTH + LEVEL - 1, 'y'), 'd')) / 7 + 1 AS WEEK_GROUP
    FROM
    (
        SELECT TO_DATE('201507', 'yyyymm') AS BASE_MONTH FROM DUAL
    )
    CONNECT BY BASE_MONTH + LEVEL - 1 <= LAST_DAY(BASE_MONTH)
)
GROUP BY WEEK_GROUP
ORDER BY WEEK_GROUP;