Query1

• Oracle 쿼리로 달력 만들기 코드 SELECT * FROM ( SELECT MIN(DECODE(TO_CHAR(YM + LEVEL -1, 'd'), '1', LEVEL)) SUN , MIN(DECODE(TO_CHAR(YM + LEVEL -1, 'd'), '2', LEVEL)) MON , MIN(DECODE(TO_CHAR(YM + LEVEL -1, 'd'), '3', LEVEL)) TUE , MIN(DECODE(TO_CHAR(YM + LEVEL -1, 'd'), '4', LEVEL)) WED , MIN(DECODE(TO_CHAR(YM + LEVEL -1, 'd'), '5', LEVEL)) THU , MIN(DECODE(TO_CHAR(YM + LEVEL -1, 'd'), '6', LEVEL)) FRI , MIN(DECODE(TO_CHAR.. Oracle 2021. 2. 16.