oracle保留兩位小數

oracle保留兩位小數

round()

四捨五入保留兩位

select round(0.113, 2) from dual;

trunc()

擷取保留兩位

select trunc(0.232, 2) from dual;