Oracle Data Types

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

Access Project | Settings | Database Datatypes

Data Types

Data Type


See also


The NUMBER data type requires precision and scale properties.

The 'Precision' and 'Scale' fields are displayed on the 'Attributes' page of the 'Features' dialog 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


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