RE: interesting floating point problem with oracle

[Mercadante, Thomas F]

Title: interesting floating point problem with oracle

 

me either...

 

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.

 

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production
With the Partitioning option
JServer Release 8.1.7.1.1 - Production

 

11:00:27 WTWD> select 62.323/62.323 from dual;

 

62.323/62.323
-------------
            1

 

11:00:33 WTWD>

 

 

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 25, 2001 11:35 AM
To: Multiple recipients of list ORACLE-L
Subject: interesting floating point problem with oracle

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 - [EMAIL PROTECTED]
"Doing linear scans over an associative array is like
trying to club someone to death with a loaded Uzi."
    - Larry Wall (creator of Perl)