SQL & PL/SQL

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!

BINARY_DOUBLE Usage Questions

624104Nov 10 2009 — edited Apr 21 2010

Hey experts,

Trying to work with the BINARY_DOUBLE data type, docs say the max value for this data type is 1.79769313486231E+308. But for some reason the max I can insert 1.79769313486231E+*125*. What am I missing? I need to store java.Double values in a fact table and I have values that approach the Double.MAX value. Can anyone provide insight as to what I'm messing up here? :)

Many Thanks,
TimS

This post has been answered by Centinul on Nov 10 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 19 2010

Added on Nov 10 2009

4 comments

1,479 views