The TO_BINARY_DOUBLE function in Oracle SQL / PLSQL is used to convert a numeric value into TO_BINARY_DOUBLE.
Syntax for the TO_BINARY_DOUBLE function in Oracle SQL / PLSQL is:
SELECT TO_BINARY_DOUBLE (number)
Let’s take an example for understanding:
Suppose we want to convert a number “2345.67” into TO_BINARY_DOUBLE.
SELECT TO_BINARY_DOUBLE(2345.67) FROM dual;
The output of the above statement will be: