I tried to find that document on Metalink and was unsuccessful. Can you suggest any search times that would return it? Do they mention any OS/RDBMS versions where you can duplicate the problem?
I tried that query on several versions of Oracle (7.3.4, 8.0.6, 8.1.5, 8.1.6, 8.1.7) on Windows NT, Windows 2000, SunOS and always got back a result of 1.
-----Original Message-----
From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]]
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;
