有数据后不能更改
1.增加一个字段来保存数据
alter table table_name add (col1 number(14,2))
update table_name set col1 = round(col,2)
2.alter table table_name drop column col
3.alter table table_name add (col number(14,2))
4 update table_name set col = col1
5.alter table table_name drop column col1
转载于:https://www.cnblogs.com/Kevin1002/p/7068688.html