CAST() 函数

作用: 四舍五入
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