I have recently started to use the package ROracle to exchange data between R and Oracle, but I have a precision problem when retrieving numbers with decimal digits. Here's an example:
#With library ROracle:
out<-dbGetQuery(conRORA, "select 1.39 from dual")
dbDisconnect(conRORA)
[1] TRUE
#but:
out[1,]==1.39
[1] FALSE
out[1,]-1.39
[1] 2.22044604925e-16
The number extracted with ROracle differs from the same number written directly in the console. Anyone else had the same problem? is there some configuration to resolve this? I know it seems insignificant but it could give unexpected results when comparing numbers in Oracle with numbers in R.
Thanks