TO_BINARY_DOUBLE Function in Oracle SQL – PLSQL

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

Tagged , , , , , , , , , , , . Bookmark the permalink.