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 -> about sequence in oracle

about sequence in oracle

From: Leader <sohelcsc_at_yahoo.com>
Date: 12 Aug 2001 22:35:26 -0700
Message-ID: <b1a93c73.0108122135.4c9625a7@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 - 00:35:26 CDT












Original text of this message













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