Fine on Oracle 7.3.4.0.1 and 7.3.4.5.1 on Novell and 7.3.4.0.1 on Redhat Linux 7.0
ROR m���m
>>> [EMAIL PROTECTED] 09/25/01 12:50PM >>>
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)
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
