Skip to Main Content

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!

Precision and Scale in NUMBER datatype

VitaminDNov 13 2009 — edited Nov 16 2009
In oracle, if you want to store a number like 892.34, you need to declare the NUMBER type like
number(5,2)
Here 5 stands for the total number of digits including the numbers after the decimal point.
2 stands the number of digits to the right of the decimal.

Isn't this confusing? Can't they just make the syntax like
number(3,2)
where 3 is the number of digits from left till the decimal and 2 is the number of digits after the decimal.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 14 2009
Added on Nov 13 2009
8 comments
3,497 views