Oracle Number Function - Oracle/PLSQL TO_BINARY_DOUBLE Function






TO_BINARY_DOUBLE(x) converts x to a BINARY_DOUBLE.

Syntax

TO_BINARY_DOUBLE(x)

x is the value to convert to.

Example


SQL> select TO_BINARY_DOUBLE(123123123) from dual;

TO_BINARY_DOUBLE(123123123)
---------------------------
                 1.231E+008

SQL>