2.1.17 Numeric

The Numeric data type is functionally equivalent to the Decimal data type. Both data types support a range of values from -1038 + 1 through 1038 – 1. The user can specify the data type to have the following values for its Precision and Scale attributes.

Data type attribute

Range

Default

Precision

From 1 through 38.

18

Scale

From 0 to the Precision that the user sets.

0

The values of this data type are represented in simple Unicode string format, as follows.

 Numeric = ["-"] 0*38DIGIT ["."0*38DIGIT]