WITH TEMP AS (
SELECT 1 AS COL1, '20110101' AS COL_FROM, '20110102' AS COL_TO FROM DUAL UNION ALL
SELECT 3 AS COL1, '20110101' AS COL2, '20110103' AS COL3 FROM DUAL
)
,TEMP2 AS (
SELECT TO_CHAR(TO_DATE('20101231','YYYYMMDD')+LEVEL,'YYYYMMDD') AS COL1 FROM DUAL CONNECT BY LEVEL <= 365
)
SELECT  A.COL1
       ,B.COL1
  FROM  TEMP A
       ,TEMP2 B
 WHERE  B.COL1 BETWEEN A.COL_FROM AND A.COL_TO
ORDER BY 1,2
;
 

with t as (
select '사번1' sbn, '20110101' sdt, '20110102' edt from dual union all
select '사번2', '20110101', '20110103' from dual union all
select '사번3', '20110101', '20110105' from dual
)
select a.sbn
     , to_char(to_date(a.sdt, 'yyyymmdd') + b.rn - 1, 'yyyymmdd') dt
  from (
         select sbn
              , sdt
              , edt
              , (to_date(edt, 'yyyymmdd') - to_date(sdt, 'yyyymmdd')) + 1 dif
           from t
       ) a
     , (
         select level rn
           from dual
        connect by level <= 100
       ) b
 where b.rn <= a.dif
 order by 1, 2

감사합니다.^^

아...또 배우고갑니다.