Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The TO_BINARY_FLOAT function converts a text or numeric expression to a SHORTDECIMAL numeric expression.
SHORTDECIMAL
TO_BINARY_FLOAT(expr [, fmt [, nlsparam ] ])
A text or a numeric expression. When expr is a text expression, the function converts the following case-insensitive values to particular values:
INF
to positive infinity
-INF
to negative infinity
NaN
to NaN
(not a number)
A text expression that specifies a number format model. This argument is valid only when expr is a text expression.
The default number format model uses the decimal and thousands group markers identified by NLS_NUMERIC_CHARACTERS.
Note:
You cannot use a floating-point number format element (F, f, D, or d) in a text expression.A text expression that specifies how the function uses the thousands group marker, decimal marker, and currency symbols when converting a text expression. This argument is valid only when expr is a text expression. This expression contains one or more of the following parameters, separated by commas:
NLS_CURRENCY symbol
NLS_ISO_CURRENCY territory
NLS_NUMERIC_CHARACTERS dg