Description: TO_BINARY_FLOAT returns a single-precision floating-point number.
expr can be a character string or a numeric value of type NUMBER, BINARY_FLOAT, or BINARY_DOUBLE. If expr is BINARY_FLOAT, then the function returns expr.
The optional 'fmt' and 'nlsparam' arguments are valid only if expr is a character string. They serve the same purpose as for the TO_CHAR (number) function.
o The incase-sensitive string 'INF' is converted to positive infinity.
o The incase-sensitive string '-INF' is converted to negative identity.
o The incase-sensitive string 'NaN' is converted to NaN (not a number).
You cannot use a floating-point number format element (F, f, D, or d) in a character string expr.
Conversions from character strings or NUMBER to BINARY_FLOAT can be inexact, because the NUMBER and character types use decimal precision to represent the numeric value and BINARY_FLOAT uses binary precision.
Conversions from BINARY_DOUBLE to BINARY_FLOAT are inexact if the BINARY_DOUBLE value uses more bits of precision than supported by the BINARY_FLOAT.
Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 05th, 2009
--The following example converts a value of datatype NUMBER -- to a value of datatype BINARY_FLOAT:SELECT dec_num, TO_BINARY_FLOAT(dec_num)FROM float_point_demo;
DEC_NUM TO_BINARY_FLOAT(DEC_NUM)---------- ------------------------1234.56 1.235E+003
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.