Online Documentation for SQL Manager for Oracle

Setting autoincrement options

If the field type is set to NUMBER and the Autoincrement option is checked then you can directly set options for creating an autoincrement field. The sequence with the specified options is created on creating such field.

This feature is enabled in Oracle Database 12c.

You can select an existing sequence for generating field values. Use the Schema and Sequence drop-down lists for this purpose.

If you want to configure new sequence manually then check the Manual option.

Check the Generate always option to increment the default value on every insertion and store the incremented value into the column.

For details on configuring other options see Sequences.