My Oracle Support Banner

RDBPROD: Floating Point Data and Rounding Errors (Doc ID 65318.1)

Last updated on OCTOBER 21, 2019

Applies to:

Oracle Rdb Server on OpenVMS - Version 6.0 and later
HP OpenVMS VAX
HP OpenVMS Itanium
HP OpenVMS Alpha


Purpose

Discuss floating point data and rounding errors.

Oracle Rdb uses floating point datatypes for all division operations. Beginning in Oracle Rdb 7.2.5.0, DOUBLE PRECISION results are produced. In prior versions, divide operations that involved small numeric values (TINYINT, SMALLINT, and short integer literals) resulted in REAL results (single precision) with some loss of accuracy.

Floating point arithmetic is described in detail at the following web sites:

What Every Computer Scientist Should Know About Floating-Point Arithmetic
Floating point, From Wikipedia, the free encyclopedia
What Every Programmer Should Know About Floating-Point Arithmetic or Why don’t my numbers add up?

Scope

This information applies to anyone viewing the results of floating point arithmetic.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.