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

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Fri, 21 Jan 2005 08:47:10 +0100
Message-ID: <csqc2r$3cs$1@news.BelWue.DE>

edzard_at_volcanomail.com wrote:
> 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
>

That's what I wrote (to join two datasets without a join condition is called a cartesian product).

But since getting a feedback gets rarer and rarer lastly, I'm still glad we could help you, so thanks for the acknowledgement.

Cheers,
Holger Received on Fri Jan 21 2005 - 01:47:10 CST