Oracle Number Data-Type
Just got a little question when a column got the Datatype Number(6,3) will thi开发者_JAVA技巧s work?
1234
1234.23
12345
123456
btw google didnt help me :/
No, this won't.
NUMBER(6, 3) accepts 6 digits at all with 3 being after the decimal period.
This gives us only 3 digits possible before the period, and, hence, maximal value possible to store is 999.999
加载中,请稍侯......
精彩评论