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

"Arijit Chatterjee" <arijitchatterjee123_at_yahoo.co.in> a écrit dans le message de news:ea01504d.0411010257.36ff4f77_at_posting.google.com...
> Dear Faculties,
> Is there any query to fine out the deleted rows from a sequence column.
> Means presently I have
> SampleTable(1 is the default sequence Start Number)
> ==========================
> Col1(Sequence Column)
> ==========================
> 7
> 8
> ==========================
> The sql output will return me
> 1
> 2
> 3
> 4
> 5
> 6
> ==========================
> Is it possible????How
> Regards
> Arijit Chatterjee

I don't check it but this may work:

select a.seq
from (select rownum seq from dual group by cube(1,2,3)) a where not exists (select 1 from sampleTable t where t.col1 = a.seq) /

-- 
Regards
Michel Cadot