values calculated on oracle with differences

Asked

Viewed 19 times

0

Good afternoon! Run the select:

SELECT 5.297800000 * 251564.541760000 FROM dual Returns the value: 1332738.62933613

I run the same calculation in a package and get the value: 1332738.629336128

With round I solve the problem, but wanted to understand what Oracle is doing. Because the correct value is the select and not the package.

Thank you!

  • The 1° must have been direct in the BD sqlplus or something I believe , in the Package were defined variables and types this can affect.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.