Last post Aug 09, 2011 09:50 AM by cenk1536
Aug 03, 2011 03:36 PM|cenk1536|LINK
I have a table on MS SQL Server which has an auto increment primary key column.Company decided to create this table on Oracle and without sequence on this field.I mean I have to update the index for this column every time I want to insert something to this
table. I am asking, is this logical?Wouldn't it be much more simpler and accurate with a sequence for this field??
Aug 03, 2011 03:39 PM|Lannie|LINK
Agree, duplicate auto-incrementing in Oracle with Oracle Sequence Object.
Presuming the table will no longer be used in MS SQL.
Aug 09, 2011 09:50 AM|cenk1536|LINK
company realized the fact and changed it to sequence :)