RE: interesting floating point problem with oracle

Even 9.0.1 computes it as 1.

And so does 8.0.6 ..

• Kirti

> -----Original Message-----
> From: Thater, William [SMTP:ThaterW_at_telergy.net]
> Sent: Tuesday, September 25, 2001 12:05 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: interesting floating point problem with oracle
>
> At 11:35 AM 9/25/2001, Adams, Matthew (GEA, 088130) wrote:
>
> >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;
>
> hmmmmm... i get 1 on 7.3.4, 8.1.5, 8.1.6 and 8.1.7.
>
> guess i must be lucky, huh?;-)
>
> maybe that's why i survive the 300 person lay off yesterday.;-)
>
>
>
> --
> Bill "Shrek" Thater ORACLE DBA
> Telergy,Inc. thaterw_at_telergy.net
> ------------------------------------------------------------------------
> You gotta program like you don't need the money,
> You gotta compile like you'll never get hurt,
> You gotta run like there's nobody watching,
> It's gotta come from the heart if you want it to work.
> ------------------------------------------------------------------------
> The attention span of a computer is only as long as its power cord.
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

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