modify number data type oracle

[akutty]

column magin is currently number (7,2)
alter table t_volume modify margin number (7,3)

gives an error

The following error has occurred:

ORA-01440: column to be modified must be empty to decrease precision or scale




Details:
ORA-01440: column to be modified must be empty to decrease precision or scale



However I am trying to increase the value to 3 , any ideas how to resolv ethis?

regards
Anil

 

[hoinz]

Hello,

what your system says is correct;
actually you are decreasing the number range left of the decimal point.
The '7' in 'number(7,2) is the overall length of the number.

hope this helps

 

[akutty]

oh I missed that...thanks a lot.

rgds
Anil