WITH t AS
(
SELECT 'A' id, '20140127' dt, '평일' gbn, '근무' gun FROM dual
UNION ALL SELECT 'A', '20140128', '평일', '특별휴가' FROM dual
UNION ALL SELECT 'A', '20140129', '평일', '특별휴가' FROM dual
UNION ALL SELECT 'A', '20140130', '설날', ''         FROM dual
UNION ALL SELECT 'A', '20140131', '설날', ''         FROM dual
UNION ALL SELECT 'A', '20140201', '휴일', ''         FROM dual
UNION ALL SELECT 'A', '20140202', '휴일', ''         FROM dual
UNION ALL SELECT 'A', '20140203', '평일', '연차'     FROM dual
UNION ALL SELECT 'A', '20140204', '평일', '근무'     FROM dual
UNION ALL SELECT 'A', '20140205', '평일', '연차'     FROM dual
)
SELECT id
     , MIN(sdt) ||'~'|| MAX(edt) ||
       ' 총휴일 '|| SUM(cnt) ||'일('||
       wm_concat(gun||' '||cnt||'일') ||')' x
  FROM (SELECT id, grp, gun
             , MIN(dt) sdt
             , MAX(dt) edt
             , COUNT(gun) cnt
          FROM (SELECT id, dt, gbn, gun
                     , TO_DATE(dt, 'yyyymmdd')
                     - ROW_NUMBER() OVER(PARTITION BY id ORDER BY dt) grp
                  FROM t
                 WHERE (gun != '근무' OR gbn != '평일')
                   AND id = 'A'
                )
         GROUP BY id, grp, gun
        )
 WHERE gun IS NOT NULL
 GROUP BY id, grp
;

너무나 감사합니다. 좋은 하루 되세요~