The NUMBER data type is used in PL sql stored programs.It's used to store fixed point or floating point numbers.
The Syntax is as follows:
NUMBER(precision,scale)
where precision is the total number of digits and scale is the number of digits to the right of decimal point.
The maximum precision of a number is 38 digits. If the precision is not mentioned it defaults to 38.
The scale ranges from -84 to 127. The scale determines the rounding of decimal digits.
More information can be found in the following link:
http://download.oracle.com/docs/cd/B10500_01/appdev.920/a96624/03_types.htm
No comments:
Post a Comment