1. 数据类型转化 select round(1.00, 2) from dual; select trunc(1.0, 2) from dual; select CAST(12 AS NUMBER (10, 2) ) as aa from dual ;