The following table lists limitations on the numeric values in . limitationsnumeric values data typesnumeric limitations

This table lists the limitations on numeric values. Value Limit Largest negative INTEGER -2,147,483,648 Largest positive INTEGER 2,147,483,647 Largest negative BIGINT -9,223,372,036,854,775,808 Largest positive BIGINT 9,223,372,036,854,775,807 Largest negative SMALLINT -32,768 Largest positive SMALLINT 32,767 Largest decimal precision 31 Largest negative DOUBLE -1.7976931348623157E+308 Largest positive DOUBLE 1.7976931348623157E+308 Smallest negative normalized DOUBLE -2.2250738585072014E-308 Smallest positive normalized DOUBLE 2.2250738585072014E-308 Smallest negative denormalized DOUBLE -4.9E-324 Smallest positive denormalized DOUBLE 4.9E-324 Largest negative REAL -3.4028235E+38 Largest positive REAL 3.4028235E+38 Smallest negative normalized REAL -1.17549435E-38 Smallest positive normalized REAL 1.17549435E-38 Smallest negative denormalized REAL -1.4E-45 Smallest positive denormalized REAL 1.4E-45