select sum(222.3300+11.2200) from dual;
结果:233.55
期望:233.5500
解决一:
select trim(to_char(sum(222.3300+11.2200),999999990.9999)) from dual;
结果:233.5500
解决二:
CAST()函数:cast( 列名/值 as 数据类型 )
select cast(sum(22.000+11.000) as decimal(10,4)) as sumdecfrom dual;