Number - Fixed-point number
Table of Contents
1 - About
These numbers are stored internally in a scaled-integer form, typically in binary but sometimes in decimal.
Because fixed-point numbers have limited precision, only a subset of real or rational numbers are exactly representable; other numbers can be represented only approximately.
Fixed-point numbers also tend to have a more limited range of values than floating point, and so the programmer must be careful to avoid overflow in intermediate calculations as well as the final results.
2 - Articles Related
3 - Definition
3.1 - Precision
Precision is the total number of digits.
- The number 00123456.78 has a precision of 8
If a value exceeds the precision, then Oracle returns an error.
3.2 - Scale
- The number 00123456.78 has a positive scale of 2
If a value exceeds the scale, then Oracle rounds it.
The scale can range from -84 to 127.
3.2.1 - Positive
Positive scale is the number of significant digits to the right of the decimal point to and including the least significant digit.
3.2.2 - Negative
Negative scale is the number of significant digits to the left of the decimal point, to but not including the least significant digit. For negative scale the least significant digit is on the left side of the decimal point, because the actual data is rounded to the specified number of places to the left of the decimal point. For example, a specification of (10,-2) means to round to hundreds.