But doesn't that column only allow numbers of the form ".NN"? How would you expect 1.50 to fit into that?

Dave Trower

Ranch Hand

Posts: 87

posted 6 years ago

I think Paul disovered the problem.
So if I want to able to store fields like 10.25, would I need the Oracle column to be number(4,2)?
This is suppose to represent the number of hours worked per day (which cannot be higher than 24) and we want two decimal places.