1.#INF and 1.#QNAN binary double and float values Querying Oracle binary_double and binary_float columns can result in values as 1.#INF and 1.#QNAN whereas other values are just numerical broken numbers.
These binary columns are implementations of IEEE Standard 754 Floating Point Numbers. These can be assigned values as just floating point numbers. There are 2 special values however:
INF to denote infinity
NAN to denote Not a Number
To read more about these column types please read:
Oracle large numbers: binary_double & binary_float
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1231160384 To read more about the IEEE Standard 754 floating point numbers, see:
IEEE Standard 754 Floating Point Numbers
http://steve.hollasch.net/cgindex/coding/ieeefloat.html