Floating-Point Numbers

Description

Floating-point numbers can have a decimal point anywhere from the first to the last digit or can have no decimal point at all. An exponent may optionally be used following the number to increase the range, for example, 1.777 e-20. A scale value is not applicable to floating-point numbers, because the number of digits that can appear after the decimal point is not restricted.Binary floating-point numbers are stored using binary precision (the digits 0 and 1)(Oracle Language Reference Floating-Point Numbers)

Oracle Database provides two numeric data types exclusively for floating-point numbers:

pageBINARY_FLOATpageBINARY_DOUBLE

Last updated