select CURRENT_DATE + rownum -1 dt
from dual
connect by level <= 7;

Advertisements