EMS logo

Produkt Navigation

SQL Manager for Oracle

Unsere Partnerschaften

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

Online Bedienungsanleitung

Setting autoincrement options

If the field type is set to NUMBER and the CheckBox 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.


Field Editor - Setting autoincrement


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 CheckBox Manual option.


Check the CheckBox 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.