Auto Increment field
Dear Experts;
I have created a table with ID as auto increment field, when i issue an insert command it auto increment the ID correct, but when I issue an insert command with value in the ID (like I have the last ID no is 10) and issue an insert command with ID 50 it takes it and it saved the record with the ID 50.
As far as I know the auto increment should not allow you to put any number for inserting new record, or other wise it is not an auto increment any more.
Can any one please explain to me this problem.
Thank you very much for help.
Subject
Views
Written By
Posted
Auto Increment field
7325
January 18, 2009 03:40AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.