Dec[imal]

DEC[IMAL][(precision[,scale])]

This type of field holds fixed decimal point numbers between approximately 1-10E+31 and 10E+31. Precision is the total allowed number of digits including decimal places. The maximum precision is 31. The default precision is 5. Scale is the number of fractional digits (or decimal places.) The default scale is 0. Scale cannot be greater than precision. If only one parameter is given, it is treated as precision, and the default scale 0 is used. To estimate the storage requirement for decimal fields, round up the result of precision divided by two. If the field is specified as NOT NULL WITH DEFAULT, null values will be replaced by zero.