RE: interesting floating point problem with oracle

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

>>> lisa.koivu_at_efairfield.com 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:MATT.ADAMS_at_APPL.GE.COM]
> 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 - matt.adams_at_appl.ge.com
> "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: RROGERS_at_galottery.org

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: ListGuru_at_fatcity.com (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).