9버젼에서 view merge가 일어나서 안되는 경우가 있더군요

SELECT

TO_DATE(SUBSTR(open_dt,0,8),'YYYYMMDD')+ LEVEL-1 

FROM  (select * from T_GOODS where rownum > 0) 

WHERE 1=1 

AND gd_seq = 'GD000027'

CONNECT BY LEVEL <= (TO_DATE(SUBSTR(close_dt,0,8),'YYYYMMDD')-TO_DATE(SUBSTR(open_dt,0,8),'YYYYMMDD')+1);

혹은

SELECT DT+ LEVEL-1
FROM  (
        SELECT TO_DATE(SUBSTR(open_dt,0,8),'YYYYMMDD')   DT
               ,(TO_DATE(SUBSTR(close_dt,0,8),'YYYYMMDD')-TO_DATE(SUBSTR(open_dt,0,8),'YYYYMMDD')+1) CNT
          FROM T_GOODS
         WHERE 1=1
        --AND gd_seq = 'GD000027'
      )
CONNECT BY LEVEL <= CNT