[php]
SQL> select e.dt+4,to_char(dt+4,'d') from (
2select d.*,max(rn) over(partition by dt order by dt) trn from (
3select c.*,row_number() over(partition by dt, d order by rdt) rn from (
4select a.dt, a.dt + b.rn rdt, to_char(a.dt + b.rn, 'd') d
5from (select to_date(2000 + rownum || '-5-1', 'yyyy-mm-dd') dt
6
from dual
7
connect by rownum 3)e where trn=4 and d=3
12/
E.DT+4TO_CHAR(DT+4,'D')
----------- -----------------
2004-5-54
2010-5-54
2021-5-54
2027-5-54
2032-5-54
2038-5-54
2049-5-54
2055-5-54
2060-5-54
2066-5-54
2077-5-54
2083-5-54
2088-5-54
2094-5-54
2100-5-54
15 rows selected
SQL>
[/php]
|