locked
How accurate is this??? RRS feed

  • 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.

    Wednesday, August 3, 2011 3:36 PM

Answers

  • User269602965 posted

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

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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, August 3, 2011 3:39 PM

All replies

  • User269602965 posted

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

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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, August 3, 2011 3:39 PM
  • User-1104215994 posted

    company realized the fact and changed it to sequence :)

    Tuesday, August 9, 2011 9:50 AM