17,089
社区成员
发帖
与我相关
我的任务
分享
SQL> with a as(select 4 value,50 count from dual
2 union
3 select 5,18 from dual)
4 select b.rn,a.count from a,(select rownum rn from dual connect by rownum<=5) b
5 where a.value(+)=b.rn
6 order by rn
7 /
RN COUNT
---------- ----------
1
2
3
4 50
5 18
SQL>