select to_char(RQ,'iw'),RQ, RQ + 7
from (select to_date(2010 || '0101', 'yyyymmdd') + rownum - 1 rq,
to_char(to_date(2010 || '0101', 'yyyymmdd') + rownum - 1,
'day') rd
from (select rownum
from dual
connect by rownum <= to_date(2010 || '1231', 'yyyymmdd') -
to_date(2010 || '0101', 'yyyymmdd') + 1))
where rd = '星期日'