Oracle Data Types

The Oracle data types NUMBER and VARCHAR have additional properties that you can model.

Access

Ribbon

Configure > Reference Data > Settings > Database Datatypes

Data Types

Data Type	Detail	See also
NUMBER	The NUMBER data type requires precision and scale properties. The 'Precision' and 'Scale' fields are displayed on the 'Attributes' page of the Features window when the data type is set to NUMBER; if you enter information into these fields, it is displayed on your diagrams. For example: create NUMBER by setting 'Precision' = 0 and 'Scale' = 0 create NUMBER(8) by setting 'Precision' = 8 and 'Scale' = 0 create NUMBER(8,2) by setting 'Precision' = 8 and 'Scale' = 2
VARCHAR	Oracle VARCHAR2(15 CHAR) and VARCHAR2(50 BYTE) data types can be created by adding the Tagged Value LengthType with the value CHAR or BYTE.

Data Type

Detail

See also

NUMBER

The NUMBER data type requires precision and scale properties.

The 'Precision' and 'Scale' fields are displayed on the 'Attributes' page of the Features window when the data type is set to NUMBER; if you enter information into these fields, it is displayed on your diagrams.

For example:

create NUMBER by setting 'Precision' = 0 and 'Scale' = 0

create NUMBER(8) by setting 'Precision' = 8 and 'Scale' = 0

create NUMBER(8,2) by setting 'Precision' = 8 and 'Scale' = 2

VARCHAR

Oracle VARCHAR2(15 CHAR) and VARCHAR2(50 BYTE) data types can be created by adding the Tagged Value LengthType with the value CHAR or BYTE.

Learn more

Database Datatypes
Assign a Tagged Value to an Item