转换数字精度可以使用cast来实现
oracle示例如下:
select CAST(1234.4234234123643552435 AS NUMBER (11, 4) ) from dual
mysql 示例如下:
select CAST(1234.4234234123643552435 AS decimal(11, 4) )
转换数字精度可以使用cast来实现
oracle示例如下:
select CAST(1234.4234234123643552435 AS NUMBER (11, 4) ) from dual
mysql 示例如下:
select CAST(1234.4234234123643552435 AS decimal(11, 4) )