Online Documentation for SQL Manager for Oracle

Setting field name and type


Column name

Enter a name for the new field, or modify the name of the field being edited. Note that the name of a field must be unique among all the field names in the table.

 

The Data type tab defines the type of the field data.

 

Field Editor - Setting field name and type

 

Column type kind

This group allows you to select whether the field being create/edited is based on a standard (built-in) data type, an ANSI SQL data type, or a user-defined type.

 

RadioButton Oracle built-in datatype

Specifies that the field is based on a built-in Oracle data type.

 

Type

Here you can set the field type by selecting it from the drop-down list of built-in Oracle data types.

 

RadioButton Ansi SQL datatype

Specifies that the field is based upon a user-defined data type.

 

Type

Here you can set the field type by selecting it from the drop-down list of ANSI SQL data types.

 

Size

Specify the length of the field value (for certain types).

 

Scale

Defines the maximum number of decimal digits that can be stored to the right of the decimal point of the value (for numeric and decimal data types).

 

CheckBox Not NULL

Check this option to specify that the values for the column should never contain a null value. NOT NULL affects all INSERT and UPDATE operations on a column.

 

CheckBox Unique

Check this option to create a unique key on the field that provides entity integrity for a particular column or columns using a unique index.

 

CheckBox Autoincrement

Enable the option to create an autoincremental field using trigger and sequence for Oracle Database 11g and lower.

For Oracle Database 12c use the Identity tab to configure autoincrement properties.

 

CheckBox Virtual

Enable the option to create a calculated field. Use the Column Expression tab to define expression that will be used to calculate this field's values.

 

CheckBox Default On Null

Check this option to set default column value when it is explicitly set to NULL.

 

RadioButton User-defined data type

Specifies that the field is based upon a user-defined data type.

 

Schema

Use the drop-down list to select the schema containing the user-defined type.

 

Type

Use the drop-down list to select the user-defined type (Array Type, Index Type or Object Type) for the field being created/edited.