Question

explain the basic data types field in open office base with example​

Answer 1

Answer:

Numeric Types

Numeric TypesName Data type Range

Numeric TypesName Data type RangeNUMERIC number (Max Scale, Max Precision ) Max Scale = unlimited Max Precision = e(+/-)231

Numeric TypesName Data type RangeNUMERIC number (Max Scale, Max Precision ) Max Scale = unlimited Max Precision = e(+/-)231DECIMAL decimal (Max Scale, Max Precision ) Max Scale = unlimited Max Precision = e(+/-)231

Numeric TypesName Data type RangeNUMERIC number (Max Scale, Max Precision ) Max Scale = unlimited Max Precision = e(+/-)231DECIMAL decimal (Max Scale, Max Precision ) Max Scale = unlimited Max Precision = e(+/-)231REAL real 2-1074 to (2-2-52)* 21023

Numeric TypesName Data type RangeNUMERIC number (Max Scale, Max Precision ) Max Scale = unlimited Max Precision = e(+/-)231DECIMAL decimal (Max Scale, Max Precision ) Max Scale = unlimited Max Precision = e(+/-)231REAL real 2-1074 to (2-2-52)* 21023FLOAT float 2-1074 to (2-2-52)* 21023