Hi
I've created a sequence on a table using oracle 10g express edition by using the following code:
create sequence referee_seq START WITH 1 INCREMENT BY 1
I then add a row to my table by using the following code:
insert into referee values(referee_seq.NEXTVAL,'','','','','','','','' ,'','')
For some reason its skipping values so my primary keys are goin up in 2's like 2, 4, 6, 8 etc etc even though my increment is set to 1.
If anyone could shed some light as to what i'm doing wrong it would be greatly appreciated
Thanks