Oracle Data Types

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

Reference:

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: