Oracle常見數字函式

Round - 四捨五入
Trunc - 簡單擷取
Ceil - The CEIL function determines the smallest integer greater than (or equal to) a particular numeric value.
Floor - The FLOOR function determines the largest integer less than (or equal to) a particular numeric value.

Use trunc with caution when doing calculations, trunc may lead to data inaccuracy.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/638844/viewspace-1061317/，如需轉載，請註明出處，否則將追究法律責任。