脚本
select concat('alter table ', table_name, ' modify ', column_name) from information_schema.columns where table_schema = 'lyx_oracle_ucenter' and data_type = 'decimal' and NUMERIC_SCALE > 0;
脚本
select concat('alter table ', table_name, ' modify ', column_name) from information_schema.columns where table_schema = 'lyx_oracle_ucenter' and data_type = 'decimal' and NUMERIC_SCALE > 0;
转载于:https://my.oschina.net/u/3277181/blog/1476122