CODEWITHSUNDEEP
oracle-database
domiSchenk
domiSchenk

Reputation: 890

Oracle Number Data-Type

Just got a little question when a column got the Datatype Number(6,3) will this work?

1234
1234.23
12345
123456

btw google didnt help me :/

Upvotes: 4

Views: 6726

Answers (1)

Quassnoi
Quassnoi

Reputation: 425251

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

Upvotes: 11

Related Questions