Oracle PL/SQL/Data Type/TO BINARY DOUBLE

TO_BINARY_DOUBLE(x): Converts x to a BINARY_DOUBLE

   <source lang="sql">

SQL> --TO_BINARY_DOUBLE(x): New for Oracle Database 10g. Converts x to a BINARY_DOUBLE. SQL> CREATE TABLE float_point_demo

 2    (dec_num    NUMBER(10,2),
 3     bin_double BINARY_DOUBLE,
 4     bin_float  BINARY_FLOAT);

Table created. SQL> SQL> INSERT INTO float_point_demo VALUES (1234.56,1234.56,1234.56); 1 row created. SQL> SQL> SELECT * FROM float_point_demo;

  DEC_NUM BIN_DOUBLE  BIN_FLOAT

---

---------- ----------

  1234.56 1.235E+003 1.235E+003

SQL> SQL> SELECT dec_num, TO_BINARY_DOUBLE(dec_num) FROM float_point_demo;

  DEC_NUM TO_BINARY_DOUBLE(DEC_NUM)

---

-------------------------

  1234.56                1.235E+003

SQL> SQL> drop table float_point_demo; Table dropped. SQL> SQL>

      </source>