Oracle ROUND TRUNC

ROUND:選擇小數點後要保留幾位數並四捨五入

SELECT round(107.088, 2) from dual

ROUND(107.088,2)
107.09

TRUNC:依第二個參數來決定返回的位數

TRUNC( number [, decimal_places] )

SELECT trunc(107.938439849, 3) from dual

TRUNC(107.938439849,3)
107.938