Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: floating point and Sun T2000

Re: floating point and Sun T2000

From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Fri, 5 May 2006 13:58:53 -0500
Message-ID: <de807caa0605051158i3dd550em5ebd5142e9a5f905@mail.gmail.com>


I agree, but for a slightly different reason. Treating currency (with decimal digits) as floating point is a sure way to end up with rounding errors. Try to explain that to a manager who hasn't touched math since high school. That is why I really appreciate Oracle's NUMBER data type.

I think the original post was in reaction to Oracle's statement that it couldn't spread the F.P. operations across multiple CPU's. My guess is that the overhead to move operations to other CPUs would outweigh the benefit, but that is just a simple guess.

Dennis Williams

--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 05 2006 - 13:58:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US