作用: 四舍五入 select cast(‘9.0’ as decimal) from dual; — 9
select cast(‘9.5’ as decimal) from dual; — 10
select cast(‘9.6’ as decimal) from dual; — 10
select cast(‘9.3’ as decimal) from dual; — 9
select cast(‘9.5’ as decimal(10,3)) from dual; — 9.500
需要了解更多数据库技术:CAST() 函数,都可以关注数据库技术分享栏目—猴子技术宅(www.ssfiction.com)