Number Functions
ROUND(num, decimals)– round to decimalsTRUNC(num, decimals)– truncateMOD(x, y)– remainderCEIL(num),FLOOR(num)– round up/down
SELECT ROUND(123.456, 2), TRUNC(123.456, 2), MOD(10, 3), CEIL(4.2), FLOOR(4.8) FROM dual;ROUND(num, decimals) – round to decimalsTRUNC(num, decimals) – truncateMOD(x, y) – remainderCEIL(num), FLOOR(num) – round up/downSELECT ROUND(123.456, 2), TRUNC(123.456, 2), MOD(10, 3), CEIL(4.2), FLOOR(4.8) FROM dual;