Re: Why sequence jumps?

From: Muhammad Ismail Thahim <ismail_at_super.net.pk>
Date: Wed, 30 Jun 1999 08:54:35 +0500
Message-ID: <377994FA.D707E63C_at_super.net.pk>


use code in the post insert trigger
ismail

Mungo Henning wrote:

> Wassim wrote:
>
> > create sequence mvt_seq
> > start with 0
> > increment by 1
> > nomaxvalue
> > minvalue 0
> > nocycle
> > order (cos order is important for me!)
> >
>
> If you can't tolerate gaps in a sequence, don't use oracle
> sequences! Look up the option "nocache" on the
> create sequence command.
> What if ten people were sharing the same sequence number
> to insert records into a table, and after inserting a single
> record one person decided to rollback that insert? What
> would happen to the sequence number if the next four
> values had already been given out?
>
> Hence sequence does not infer "consecutive sequence".
>
> HTH
>
> Mungo Henning
>
> --
> Mungo Henning - it's a daft name but it goes with the face...
> mungoh_at_itacs.strath.ac.uk.http://www.itacs.strath.ac.uk/
> (since everyone else does it) I speak for me, not my employer.
Received on Wed Jun 30 1999 - 05:54:35 CEST

Original text of this message