with
t1
as
(
select
10001 c1,10005 c2,5 c3,100 c4
from
dual
union
all
select
10007 c1,10012 c2,6 c3,200 c4
from
dual
)
select
distinct
c1+
level
-1 c1,c4
from
t1
connect
by
level
<= c2 - c1 + 1
order
by
c1