2008.06.24 10:05
SELECT     SUM (DECODE (TO_CHAR (TO_DATE ('200806' || LPAD (LEVEL, 2, '0'), 'YYYYMMDD'), 'D')
                      , '1', 1
                      , 0
                       )
               ) DATE#
      FROM DUAL
CONNECT BY TO_DATE ('200806', 'YYYY-MM') + LEVEL - 1 <= LAST_DAY (TO_DATE ('200806', 'YYYY-MM'))
신고
Posted by 커피한잔의여유

티스토리 툴바