Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Oracle Number Data-Type

Tags:

oracle

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 :/

like image 577
domiSchenk Avatar asked Dec 22 '22 06:12

domiSchenk


1 Answers

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

like image 57
Quassnoi Avatar answered Jan 25 '23 21:01

Quassnoi