How accurate is this???

Question

User-1104215994 posted

Hi,

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??

Best Regards.

Answer 1

User269602965 posted

Agree, duplicate auto-incrementing in Oracle with Oracle Sequence Object.

Presuming the table will no longer be used in MS SQL.

Answer 2

User-1104215994 posted

company realized the fact and changed it to sequence :)