
Ispirer SQLWays Database Migration Software
NUMBER and FLOAT
NUMBER(p,s)
The NUMBER data type stores zero, positive, and negative fixed and floating point numbers with 38 digits of precision.
p is the precision, or the total number of digits. The precision can range from 1 to 38.
s is the scale, or the number of digits to the right of the decimal point. The scale can range from 84 to 127.
To specify integers use the following form: NUMBER(p) or NUMBER(p,0).
FLOAT[(p)]
Oracle supports the ANSI data type FLOAT. Therefore, specifying a floatingpoint number you can use FLOAT data type instead of NUMBER data type.
p is the binary precision that can range from 1 to 126. If p is not specified the default value is binary 126. To convert from binary to decimal precision, multiply p by 0.30103. To convert from decimal to binary precision, multiply the decimal precision by 3.32193. 126 digits of binary precision is roughly equivalent to 38 digits of decimal precision.