Re: real number representation

From: Mark D Powell <mark.powell_at_eds.com>
Date: 3 Jun 2001 08:44:51 -0700
Message-ID: <178d2795.0106030744.59ec7397@posting.google.com>

"Michael D. Berger & Rosalie A. Clavez" <mdberger_at_radix.net> wrote in message news:<3B191082.28D37448_at_radix.net>...
> Could someone please inform me how real numbers are represented
> internally in Oracle databases? In addition, a reference to
> documentation discussing such matters would be helpful.
>
> Thanks for your help.
> Mike.

Oracle stores all number fields within the rdbms as a form of scientific notation. You can find an explanation and the formula for figuring storage space in the Concepts manual chapter on database data types, and it should also be in the Application Developers Guide chapter on data types (at least this was true for 7.3 and 8.0 documentation).

Mark D Powell --

Received on Sun Jun 03 2001 - 10:44:51 CDT