Number Functions

Number Functions

• ROUND(num, decimals) – round to decimals
• TRUNC(num, decimals) – truncate
• MOD(x, y) – remainder
• CEIL(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;