If you want the values of a numeric column to be automatically incremented rather than duplicated when creating a table, you need an auto-increment column.
In Oracle tenants, you can use the Sequence object in the INSERT statement to set an auto-increment column. For more information about sequences, see Create and manage sequences.