四舍五入
select round(435.35,1),round(435.35), from dual //round(数字,保留几位小数)
截断
select trunc(435.35,1),trunc(435.35), from dual //trunc(数字,截断位数)
除余
select mod(1100,100) from dual;
select round(435.35,1),round(435.35), from dual //round(数字,保留几位小数)
select trunc(435.35,1),trunc(435.35), from dual //trunc(数字,截断位数)
select mod(1100,100) from dual;