Approximate numeric data types will be used to hold floating precision values.
FLOAT and REAL are the examples for approximate numeric values or floating precision values.
FLOAT data type allows the Floating precision number data with the following valid values: -1.79E + 308 through -2.23E - 308, 0 and 2.23E + 308 through 1.79E + 308.
REAL data type allows the Floating precision number data with the following valid values: -3.40E + 38 through -1.18E - 38, 0 and 1.18E - 38 through 3.40E + 38.
Syntax for the FLOAT data types is:
Float (N):
(OR)
Float
N indicates the number of bits that are used to store the mantissa of the float number
Size of the float data type varies based in the N value.
If N is between 1 and 24, then float data type used 4 bytes.
If N is between 25 and 53, then float data type used 8 bytes.
Default value of N is 53. That is by default float data type used 8 bytes and Real data type uses 4 bytes.
