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 |