RE: interesting floating point problem with oracle

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Tue, 25 Sep 2001 10:14:31 -0700
Message-ID: <F001.00397E20.20010925080529@fatcity.com>

 
me
either...
<SPAN

class=901510015-25092001> 
<SPAN

class=901510015-25092001>SQL*Plus: Release 8.1.6.0.0 - Production on Tue Sep 25 11:00:24 2001
 
(c)
Copyright 1999 Oracle Corporation.  All rights reserved.
 
<SPAN

class=901510015-25092001>Connected to:Oracle8i Enterprise Edition Release 8.1.7.1.1 - ProductionWith the Partitioning optionJServer Release 8.1.7.1.1 - Production
 
<SPAN

class=901510015-25092001>11:00:27 WTWD> select 62.323/62.323 from dual;
 
<SPAN

class=901510015-25092001>62.323/62.323-------------            1
 
<SPAN

class=901510015-25092001>11:00:33 WTWD>
<SPAN

class=901510015-25092001> 
<SPAN

class=901510015-25092001> 
Tom Mercadante <FONT face=Arial
size=2>Oracle Certified Professional

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Adams, Matthew (GEA, 088130)   [mailto:MATT.ADAMS_at_APPL.GE.COM]Sent: Tuesday, September 25, 2001   11:35 AMTo: Multiple recipients of list ORACLE-LSubject:   interesting floating point problem with oracle   ran across something interesting on metalink.   from Doc ID:  Note:1012478.7   

  Problem Description <FONT

  size=2>=================== 

  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 <FONT   size=2>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 - 12:14:31 CDT