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!

Question regarding Number-datatype

555913Mar 13 2007 — edited Mar 14 2007

Hello,

in the Oracle DB-Docs it is noted that the Number(m, p) datatype is defined with following limits:

0<=m<=38
-84<=p<=127

If the datatype only has 38 digits available, how can the precision range from -84 to 127?
I would understand a precision range from -38 to +38.

Could you please give me some examples for precision = -84 and precision = 127?

Thanks

Florian Reiser

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 11 2007

Added on Mar 13 2007

#general-database-discussions

7 comments

545 views