Oracle Data Types

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


Data Type


See also


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



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: