A floating-point number can have zero or one decimal point after any digit. This topic describes the syntax, parameters, and usage notes of floating-point numbers.
Syntax
OceanBase Database provides two types of floating-point numbers for numeric data: BINARY_FLOAT and BINARY_DOUBLE.
BINARY_FLOATis a data type for 32-bit single-precision floating-point numbers. Each value of theBINARY_FLOATtype occupies four bytes.BINARY_DOUBLEis a data type for 64-bit double-precision floating-point numbers. Each value of theBINARY_DOUBLEtype occupies eight bytes.You can specify a floating-point number based on its value range listed in the following table.