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!

number datatype leading digits > 12

367852Sep 30 2008 — edited Mar 19 2009
If a column is defined as Number it supports 12 LEADING DIGITS AND 3 DIGITS AFTER THE DECIMAL without loss of data.
However with leading digits > 12 there is a loss of data after the decimal points or gets converted to E number.

I suppose the corresponding fixed-point number will be NUMBER(15,3)

Can someone please mail more information about this, the column is intended to store amount information in billions and for some currencies may overflow the limit of 12.

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 28 2008
Added on Sep 30 2008
#general-database-discussions
7 comments
832 views