Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to retrive Deleted Sequence Number????

How to retrive Deleted Sequence Number????

From: Arijit Chatterjee <arijitchatterjee123_at_yahoo.co.in>
Date: 1 Nov 2004 02:57:13 -0800
Message-ID: <ea01504d.0411010257.36ff4f77@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 Received on Mon Nov 01 2004 - 04:57:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US