SELECT TO_CHAR(TO_DATE(V) + (LEVEL - 1),'YYYYMMDD')
FROM (SELECT '20101010' v FROM DUAL)
CONNECT BY LEVEL <= SYSDATE - TO_DATE(V) + 1

<출처> www.oracleclub.com - 오라클클럽