Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
1.#INF and 1.#QNAN binary double and float values (Read 12392 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
1.#INF and 1.#QNAN binary double and float values
08.01.09 at 16:48:29
 
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
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
SQL*XL support for 1.#INF and 1.#QNAN values
Reply #1 - 08.01.09 at 16:52:05
 
SQL*XL support for 1.#INF and 1.#QNAN values
 
Support has been built into SQL*XL to deal with these values from binary_double and binary_float columns. Version: SQL*XL 4.3.12. When querying values such as the above the value is converted to a string and displayed in the Excel cell.
 
Drivers that support binary_float and binary_double are:
OO4O , ORAOLEDB
 
Drivers that were found to not support binary_float and binary_double are: ODBC (MSDASQL) and MSDAORA.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1