1.#INF and 1.#QNAN binary double and float values


Welcome, Guest. Please Login.

ExcelLock: Locking and securing your valuable Excel spreadsheets

encOffice: Protect your Excel file easy and safe

LIT Software Forums › SQL*XL › General Usage and Feature Troubleshooting

‹ Previous topic | Next topic ›

Pages: 1

1.#INF and 1.#QNAN binary double and float values (Read 14625 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

Gerrit-Jan Linker
Linker IT Software

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.

Gerrit-Jan Linker
Linker IT Software

IP Logged

Pages: 1

LIT Software Forums › SQL*XL › General Usage and Feature Troubleshooting

‹ Previous topic | Next topic ›

Copyright (C) 1995-2007 Linker IT Software BV. All Rights Reserved. Oracle is a registered trademark of Oracle corporation. Excel and Office are registered trademarks of Microsoft corporation. Other names appearing on the site may be trademarks of their respective owners. Software, files, documents, articles and other material are provided "as is" and without warranties as to performance or mechantability or any other warranties whether expressed or implied. No warranty of fitness for a particular purpose is offered.
sitemap