查询语句，根据某个数值，自动生成查询行数，并排序，请大神帮助！

[qq_42401900]

A表
ID NUM
1 4
2 5

结果集

序号 ID NUM
1 1 4
2 1 4
3 1 4
4 1 4
1 2 5
2 2 5
3 2 5
4 2 5
5 2 5

何解？ 可以实现吗？

[zbdzjx]

with t1 as
(
select 1 id, 4 num from dual
union all
select 2 id, 5 num from dual
)
, t2 as
(
select rownum rn from dual connect by rownum <=  (select max(num) from t1)
)
select * from t1 a,t2 b
where a.num>=b.rn
order by a.id, b.rn

[「已注销」]

with t1 as ( select 1 id, 4 num from dual union all select 2 id, 5 num from dual ) select t1.*,level from t1 connect by prior id = id and level <= num and prior dbms_random.value is not null;

[qq_42401900]

谢谢你们！，都可以。