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

"Holger Baer" <holger.baer_at_science-computing.de> a écrit dans le message de news:cma7du$62c$1_at_news.BelWue.DE...
> Michel Cadot wrote:
> > "Arijit Chatterjee" <arijitchatterjee123_at_yahoo.co.in> a écrit dans le message de
> > news:ea01504d.0411020038.32ddad72_at_posting.google.com...
> >
> >>Respected faculties,
> >>Is it possible through a query
> >>without selecting any user table
> >>showing this type of output
> >>===========================
> >>Col1
> >>----
> >>1
> >>2
> >>3
> >>4
> >>....
> >>....
> >>900000
> >>===========================
> >>Through this query I can solve this problem.
> >>Regards
> >>Arijit Chatterjee
> >
> >
> > 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.

-- 
Regards
Michel Cadot