Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Data Type: on storing data as NUMBER versus BINARY_DOUBLE?

temMar 1 2012 — edited Mar 2 2012
My application does a lot of scientific number crunching. The math uses double precision variables in both C and Java (both based off of IEEE 754).

If my goal is to store these variables in Oracle 11.2G database between computations such that the value read OUT OF the database is an exact match with the value used to write into the database, would you recommend storing such variables as an Oracle Data Type of NUMBER of BINARY DOUBLE?

And, Why?

Here I'm only concerned about accuracy (not speed nor storage).
This post has been answered by JustinCave on Mar 1 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 30 2012
Added on Mar 1 2012
#general-database-discussions
13 comments
3,017 views