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

Detail

See also

NUMBER

The NUMBER data type requires precision and scale properties.

The Precision and Scale fields are displayed on the Attributes 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

 

 

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