Numeric limitations There are limitations on the numeric values in . limitationsnumeric values data typesnumeric limitations Numeric limitations Value Limit Smallest INTEGER -2,147,483,648 Largest INTEGER 2,147,483,647 Smallest BIGINT -9,223,372,036,854,775,808 Largest BIGINT 9,223,372,036,854,775,807 Smallest SMALLINT -32,768 Largest SMALLINT 32,767 Largest decimal precision 31 Smallest DOUBLE -1.79769E+308 Largest DOUBLE 1.79769E+308 Smallest positive DOUBLE 2.225E-307 Largest negative DOUBLE -2.225E-307 Smallest REAL -3.402E+38 Largest REAL 3.402E+38 Smallest positive REAL 1.175E-37 Largest negative REAL -1.175E-37