日期:2014-05-17 浏览次数:20883 次
with t as
(select 'a' col1, 1 col2, 3 col3
from dual
union all
select 'b', 2, 5
from dual
union all
select 'c', 9, 33 from dual)
select distinct col1, col2 + level - 1
from t
connect by level <= col3 - col2 + 1
order by col1;