Oracle Database Discussions

hello all

i hava a database containing data in that there is a table which contan a number datatype
that is number(10)



the table contain large amount of data


now i need the precision value 2

that is number(10,2)

how i can update is

i try alter command the do this bu the error is there the table contain data

so please suggest the solution

thanks in advance