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

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 2 Nov 2004 19:46:06 +0100
Message-ID: <4187d5ce$0$32224$626a14ce@news.free.fr>

"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.

-- 
Regards
Michel Cadot

Received on Tue Nov 02 2004 - 12:46:06 CST