sql

with t as (select level as n from dual connect by level <= 10)
select t.n, to_char(trunc(sysdate)+t.n,'yyyy.mm.dd, day')
  from t;