RE: interesting floating point problem with oracle

[Farnsworth, Dave]

Title: RE: interesting floating point problem with oracle

>-(VIKING-SYSTEM)>

 

Is this prompt pure coincidence???  ;o)

 

Dave

-----Original Message-----
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 25, 2001 11:50 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: interesting floating point problem with oracle

Well...   not on 8.1.7.  It's fine here.

(VIKING-SYSTEM)>select 62.323/62.323 from dual;

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

Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117

-----Original Message-----
From:   Adams, Matthew (GEA, 088130) [SMTP:[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)