You can specify the attribute type, precision, and scale using the following values.
|
Attribute Type |
Description |
|
VARCHAR2 (n) |
Variable length character string -> relations |
|
NUMBER (p,s) |
Number having precision p and scale s -> relations |
|
DATE |
Valid date range |
|
BFILE |
Pointer to binary file on disk |
|
BLOB |
Binary large object |
|
CHAR |
Fixed length character data CHAR(20) |
|
CLOB |
Character Large Object |
|
Long |
Long |
|
NChar |
National |
|
NCLOB |
National Character Large Object |
|
Nvarchar2 (n) |
National Character. |
|
Raw (n) |
Raw binary data |
|
TimeStamp (n) |
Number of digits in the fractional part of the SECOND date time field |
For more information refer to Oracle Administrator's Guide.