Re: Sequence and inserting row
From: gti_matt <gtimatt_at_home.com>
Date: Wed, 05 Dec 2001 15:36:37 GMT
Message-ID: <9arP7.46029$Sx.11913563_at_news1.elcjn1.sdca.home.com>
Date: Wed, 05 Dec 2001 15:36:37 GMT
Message-ID: <9arP7.46029$Sx.11913563_at_news1.elcjn1.sdca.home.com>
"Stjepan Brbot" <Stjepan.Brbot_at_ZG.HiNet.HR> wrote in message
news:9uj11r$d552$1_at_as201.hinet.hr...
> Primary Key Column (ID) (unique) is populated from sequence and i.e.
> current lastvalue of sequencer is 500. After that I manually insert row
> with ID=600. What would happend when sequencer reaches number 600 and I
> want to insert new row? Would it overwrite it or take the next value 601
> to insert new row.
It will try to insert 600 and you will get a DUP_VAL_ON_INDEX error. Sequences just generate numbers and they don't care what you use it for, what's in a table already, etc.
-Matt Received on Wed Dec 05 2001 - 16:36:37 CET