The number data type stores numbers that can be positive or negative with defined maximum precision and scale.
The precision of the numeric data type is the number of significant digits that can be used.
The following table lists some examples of the NUMBER data type.
|NUMBER(4)||An integer with a maximum length of four digits|
|NUMBER(6,2)||A number with a maximum precision of six digits; at most two digits behind the decimal point|
|NUMBER(7,-3)||A multiple of thousand with at most seven digits|
|NUMBER||Identical to NUMBER(38,*)|
|NUMBER(*,5)||Identical to NUMBER(38,5)|