REAL- Single-precision floating-point numbers

You use the data type REAL for columns that can store single-precision floating-point numbers (see section "Numeric values").

---

[{[ dimension ] | ( dimension )}] REAL

---

dimension

Unsigned integer between 1 and 255. The column is a multiple column;
dimension indicates the number of column elements.

Any square brackets shown here in italics are special characters, and must be specified in the statement.

dimension omitted:
The column is an atomic column.

Range of values for REAL columns

A REAL column can contain floating-point numbers whose value is 0 or ranges from 5.4E^-79 to 7.2E ⁺⁷⁵.

The precision of REAL floating-point numbers is 21 binary digits, which is approximately 6 decimal digits.

Example

You define a REAL column weight as follows:

weight REAL