Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
Topic |
| Prev | Next |
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' 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
