Stores numeric values.
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).
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:
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