Re: Why sequence jumps?

[Quoted] I tbink you mean pre-insert.

M

Muhammad Ismail Thahim wrote in message <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 Thu Jul 01 1999 - 10:57:40 CEST