Re: Table/view to generate integers from 1 to 500

Thanks for the solution.
By te way, I found that higher numbers can be generated fast, if you join TWO cubes!

SQL> run
1 select count (*)
2 from (select null from dual group by cube(1,2,3,4,5,6,7,8,9,10)) 3* ,(select null from dual group by cube(1,2,3,4,5)) COUNT(*)

     32768

 real: 820 Received on Thu Jan 20 2005 - 15:17:29 CST