WITH t(linecd, linenm, carcd, indate, groupno, g_no) AS
(
          SELECT '111111', '노선1', '101010', '2017-11-10', 100, 1 FROM dual
UNION ALL SELECT '111111', '노선1', '101010', '2017-11-11', 100, 1 FROM dual
UNION ALL SELECT '111111', '노선1', '101010', '2017-11-13', 100, 1 FROM dual
UNION ALL SELECT '111111', '노선1', '101010', '2017-11-14', 100, 1 FROM dual
UNION ALL SELECT '222222', '노선2', '202020', '2017-11-10', 100, 2 FROM dual
UNION ALL SELECT '222222', '노선2', '202020', '2017-11-11', 100, 2 FROM dual
UNION ALL SELECT '222222', '노선2', '202020', '2017-11-13', 100, 2 FROM dual
UNION ALL SELECT '222222', '노선2', '202020', '2017-11-14', 100, 2 FROM dual
)
-- 토요일만 2건으로 복제하는 방법
SELECT linecd
     , linenm
     , DECODE(lv, 1, carcd, '000000') carcd
     , TO_CHAR(TO_DATE(indate, 'yyyy-mm-dd') + lv - 1, 'yyyy-mm-dd') indate
     , groupno
     , g_no
  FROM t
     , (SELECT LEVEL lv FROM dual CONNECT BY LEVEL <= 2)
 WHERE lv <= DECODE(TO_CHAR(TO_DATE(indate, 'yyyy-mm-dd'), 'd'), '7', 2, 1)
 ORDER BY linecd, indate
;