Data type Description
FLOAT An approximate numeric data type that uses 4 bytes of storage.
The data type supports the following values: -3.402823466E+38 to -1.175494351E-38
0
1.175494351E-38 to 3.402823466E+38
DOUBLE An approximate numeric data type that uses 8 bytes of storage.
The data type supports the following values:
-1.7976931348623157E+308 to -2.2250738585072014E-308
0
2.2250738585072014E-308 to 1.7976931348623157E+308
DOUBLE PRECISION Synonym for the DOUBLE data type
REAL Synonym for the DOUBLE data type
DECIMAL An exact numeric data type whose range storage requirements depend
on the and values specified in the column
definition
DEC Synonym for the DECIMAL data type
NUMERIC Synonym for the DECIMAL data type
FIXED Synonym for the DECIMAL data type