too simple,too... 看下边, 表temp_test(AAA,BBB) AAA BBB aaa 3 bbb 2 select b.aaa,b.bbb from (select rownum num from all_objects) a,temp_test b where a.num <= b.bbb
select b.aaa,b.bbb from (select rownum num from all_objects) a,temp_test b where a.num <= b.bbb 不错,all_objects可以换成行数更多的表。如果bbb大于all_objects的行数就不准了。
看下边,
表temp_test(AAA,BBB)
AAA BBB
aaa 3
bbb 2
select b.aaa,b.bbb
from (select rownum num from all_objects) a,temp_test b
where a.num <= b.bbb
from (select rownum num from all_objects) a,temp_test b
where a.num <= b.bbb
不错,all_objects可以换成行数更多的表。如果bbb大于all_objects的行数就不准了。