Different processors implement floating-point arithmetic differently.
Besides, Oracle may be ran on a platform with no FPU unit whatsoever.
At the same time, Oracle guarantees portability of values with precision
up to 38 decimal digits across all supported platforms. No wonder they
implemented floating-point math that way...
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Jaroslaw Gramacki" <J.Gramacki_at_iie.pz.zgora.pl> wrote in message
news:3dc78493.3776520_at_news.ict.pwr.wroc.pl...
> On Tue, 5 Nov 2002 11:23:29 +0300, "Vladimir M. Zakharychev"
> <bob_at_dpsp-yes.com> wrote:
>
> >Look it up in Oracle SQL Reference - you will find everything you need to
> >know about all Oracle data types there. For PL/SQL data types, read
> >PL/SQL Developer's Guide. You can find both books searchable online at
> >http://tahiti.oracle.com - OTN registration is required (registration is free
> >and they do not spam.)
> >
> Well, I had in mind something more detailed like e.g ANSI/IEEE 754 -
> 198 standard for binary floating-point arithemtic norm description.
> With in-depth format description, operations, exceptions, etc.
> Oracle does not use math-coproc. (with build-in FPU) to perform math
> calculations but implements a whole arithmetic by itself.
>
> >--
> >Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
> >Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
> >All opinions are mine and do not necessarily go in line with those of my employer.
> >
> >
> >"Jaroslaw Gramacki" <J.Gramacki_at_iie.pz.zgora.pl> wrote in message
> >news:3dc77891.702570_at_news.ict.pwr.wroc.pl...
> >> Hello,
> >>
> >> Does anybody know any good and reliable information (e.g. a good web
> >> page, a link, etc.) concerning the details of the internal oracle
> >> datatype NUMBER. It stores data in a decimal way (not binary
> >> floating-point number) in base-100 format.
> >>
> >> Best wishes to the oracle world,
> >> Jarek
> >>
> >>
> >>
> >> --------------------------------------------
> >> Jaroslaw Gramacki, Ph.D.
> >> University of Zielona Gora, Poland
> >> e-mail : J.Gramacki_at_iie.uz.zgora.pl
> >> phone : (+48 68) 3282536
> >> fax : (+48 68) 3244733
> >
>
>
> --------------------------------------------
> Jaroslaw Gramacki, Ph.D.
> University of Zielona Gora, Poland
> e-mail : J.Gramacki_at_iie.uz.zgora.pl
> phone : (+48 68) 3282536
> fax : (+48 68) 3244733
Received on Tue Nov 05 2002 - 03:09:34 CST
