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)
FROM table_name;**

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:

TO_BINARY_DOUBLE (2345.67) |

2346E+003 |