select a.id,rate, a.start_date, a.end_date, a.start_date+b.dis h from
it_01 a,
(select rownum dis from
(select max(end_date-start_date)+1 gap from it_01)
connect by rownuma.start_date+b.dis
order by a.id,5
select a.id,rate, a.start_date+b.dis 你需要的 from
it_01 a,
(select rownum dis from
(select max(end_date-start_date)+1 gap from it_01)
connect by rownuma.start_date+b.dis
order by a.id,5
参考坏大师的资料: http://www.itpub.net/701508.html
|