oracle的sql中将字符串数字转换成数字

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;

以上可以自己验证。