开发者

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜