Re: How to retrive Deleted Sequence Number????

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Fri, 05 Nov 2004 13:03:44 +0100
Message-ID: <cmfq70$2jk$1@news.BelWue.DE>

Michel Cadot wrote:

>>>The best way i know is:
>>>
>>>select rownum
>>>from (select 1 from dual group by cube(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20))
>>>where rownum<=900000
>>>/
>>>
>>>or you can use a PL/SQL function to generate the numbers.
>>>But if you want to use SQL, you can't avoid selecting.
>>>
>>
>>At least on my test machine (10g) this is totally not viable. I started the query about 14hours

>
> ago,
>

>>and it's still running. Would you care to elaborate a bit more how to use this query?
>>

>
>
> You're perfectly right this does not really work as the query time doubles each time
> you add an element in the cube. It was just the first step for Arijit to think about a solution.
> And you get it using a cartesian between 2 cubes on 10 elements instead of generating
> a cube of 20 elements.
>

Thanks for clarifying. The phrase 'The best way i know is:' was a bit misleading, though.

Cheers,
Holger Received on Fri Nov 05 2004 - 06:03:44 CST