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;
以上可以⾃⼰验证。oracle decimal类型

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。