Re: about sequence in oracle

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 13 Aug 2001 10:08:56 +0100
Message-ID: <3b779933$0$3763$ed9e5944@reading.news.pipex.net>

It looks like you are using this column as a meaningless primary key? If this is the case what is the problem with having a non-contiguous sequence of primary key values?

You might also look at the uses , and restrictions, of the pseudo-column rownum.

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Legal disclaimer required by my employer
****************************************************************************
**
This email contains information intended for the addressee only.
 It may be confidential and may be the subject of legal and/or professional
privilege.
Any dissemination, distribution, copyright or use of this communication
without prior permission of the addressee is strictly prohibited.
****************************************************************************
**
"Leader" <sohelcsc_at_yahoo.com> wrote in message
news:b1a93c73.0108122135.4c9625a7_at_posting.google.com...


> Dear all,

>  i have a problem. that is, suppose i have created sequence for

> primary key of one table where start with 1, increment by 1, .... and

> i have inserted three rows in the table. after that i delete the rows.

> but when i insert next time primary id starts with 4. is there any

> options without droping the sequence, if i want to start the id again

> from 1.

>

> thanks,

> hoque.

Received on Mon Aug 13 2001 - 04:08:56 CDT