interesting floating point problem with oracle

From: Adams, Matthew (GEA, 088130) <MATT.ADAMS_at_APPL.GE.COM>
Date: Tue, 25 Sep 2001 08:24:43 -0700
Message-ID: <F001.00397C7A.20010925073521@fatcity.com>

ran across something interesting on metalink.

from
Doc ID:  Note:1012478.7

Problem Description

---

Doing floating point arithmetic involving multiplication and division causes unpredictable results.  For example, if you issue the following select statement from a SQL*Plus session, the result would be "~" which is incorrect.

select 62.323/62.323 from dual;

---

Matt Adams - GE Appliances - matt.adams_at_appl.ge.com "Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi."     - Larry Wall (creator of Perl) Received on Tue Sep 25 2001 - 10:24:43 CDT