Oracle SQL - Number Data type


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.

Example Description
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)