EMS logo

Products Navigation

SQL Manager for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

On-line Documentation

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.