Scale and Precision in number Data type

code_lover · March 9th, 2007, 04:34 PM

What is do we mean by scale and precision in number data type.
What it really means when we declare the following:

nm number(3,6)

Please reply in detail

MAXOOD!

Life is an endless journey towards perfection

[email protected] · April 9th, 2009, 04:56 PM

hi,
in NUMBER u store a decimal value. it can have 2 parameters like num(8,2)

8 tells that it can store upto 8 digits of value (excluding the decimal) and 2 represents number of digits after decimal like 123456.78