Numeric datatypes
Number
The number datatypes can store numeric values where s stands for the scale and p stands for the precision. The precision can range among 1 to 38 and the scale ranges from –84 to 127.
Syntax
Number (p, s)
Example:
Sal number – Here the precision is and 38 the scale is 0.
Sal number(7) – Here the number is a fixed point and the scale is 0 number of 7 digits
Sal number(7,2) – Stores 5 digits followed via 2 decimal points.