Regarding Sequence Numbers
August 3rd, 2008 By ragunathansd
Suppose I have inserted, say 10 rows into a table using sequence numbers (1-10). If I delete the 5th record from the table. Will the sequence number from 6th record get affected or will it be the same?
If it is same then please suggest some way so that the remaining records get updated, ie it should be (1-9) in sequence not (1-4 & 6-10).
August 3rd, 2008 at 3:05 pm
Are you inserting sequence numbers, from a sequence database object, into the table’s primary key? Why do you care about having, or not having, gaps in the sequence?
August 5th, 2008 at 7:43 am
I am not inserting sequence numbers from database. I need to populate the data in a grid. If a user deletes a row from the grid, the consecutive rows should be updated so that the sequence remains the same. I dont want the gap in the sequence.
Can anyone help?