Stores numeric values.
Numeric (M.N)
Where:
M
Specifies the total number of digits for the figure (including the number of decimal positions, the decimal point and the sign if you need it).
N
Specifies the number of decimal places.
The Numeric data type allows you to store a numeric value in the DMBS.
The following table illustrates the properties used to define a Numeric data type:
Other related properties to Numeric Data Type:
Sample
Suppose you define an attribute (or a variable) whose data type is Numeric, with length: 9, decimal positions: 2, and no sign. This means that you can store a figure of up to 6 digits in the part corresponding to the whole number, plus 2 decimal positions (6 digits in the part corresponding to the whole number + decimal point + 2 digits for decimal positions = 9 digits).
Maximum numeric length property