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)
