select to_date('2013/11/11', 'yyyy/mm/dd') + (rownum-1)
from dual
connect by rownum <= (to_date('2013/11/27', 'yyyy/mm/dd')+1 -
to_date('2013/10/10', 'yyyy/mm/dd'))
from dual
connect by rownum <= (to_date('2013/11/27', 'yyyy/mm/dd')+1 -
to_date('2013/10/10', 'yyyy/mm/dd'))
from (select t.*, (to_date('2013/12/23', 'yyyy/mm/dd') - field) / 7 + 1 rn
from t
where field <= to_date('2013/12/23', 'yyyy/mm/dd')) b
where exists
(select 1 from (select rownum rnn from t) a where b.rn = a.rnn)
order by field desc