select '15.5' as str from dual;
select '15.5' + 0 as str from dual;
select * from sys_resource order by id+0;--id数据类型是 varchar2
select cast('15.5678' as decimal(6,2)) as num from dual;
select to_number('16.789') as num from dual;
以上可以自己验证。
select '15.5' as str from dual;
select '15.5' + 0 as str from dual;
select * from sys_resource order by id+0;--id数据类型是 varchar2
select cast('15.5678' as decimal(6,2)) as num from dual;
select to_number('16.789') as num from dual;
以上可以自己验证。