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 -> Re: How to retrive Deleted Sequence Number????

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

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 01 Nov 2004 19:36:52 -0800
Message-ID: <1099366546.644189@yasure>


Arijit Chatterjee wrote:

> 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

What have you tried that didn't work?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Nov 01 2004 - 21:36:52 CST

Original text of this message

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