Problems When Converting Float Values To Double, Precision Not Maintained (Doc ID 2118719.1)

Last updated on MARCH 29, 2020

Applies to:

Goal

Describe what can be done after converting existing float-values into double-values with the following command:

 
Double-values with numeric precision appears which had no numeric precision respectively had fewer numeric precision on float-values.
Example:
Float Value 1.01 was converted into Double 1.00999999046326.

to restore its original value while leaving the data type as Double? How to perform this?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.