Oracle PL/SQL Tutorial - PL/SQL NUMBER

NUMBER data type stores fixed-point or floating-point numbers.

The syntax for specifying a fixed-point NUMBER is:

 
 NUMBER(precision, scale)

For example:


 NUMBER(8,2)

Example

For an integer, the scale is zero.

The syntax for specifying an integer NUMBER is:


NUMBER(precision)

For example:


NUMBER(2)