修改表字段数值类型：eg:create table haha_info(remark varchar2(10));-->alter table haha_info modify remark number(2,2);
把字符型转换成数值型：select to_number(t.remark) from haha_info t;
希望可以帮到你~~~
select to_number('10') from dual
