RE: interesting floating point problem with oracle

[Jon Baker]

Title: interesting floating point problem with oracle

I got a big fat 1 from 8.1.7.

 

Guess I'll check the doc for affected version.

 

 

-----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)