Number
Functions
• ROUND: Rounds value to a specified decimal
• TRUNC:
Truncates value to a specified
decimal
• CEIL: Returns the smallest whole number
greater than or equal to a specified number
• FLOOR: Returns the largest whole number
equal to or less than a specified number
• MOD:
Returns remainder of division
Function Purpose
ROUND(column|expression,
n) -Rounds the column, expression, or value to n decimal
places or, if n is omitted, no
decimal places (If n isnegative, numbers to the left of decimal point
are rounded.
TRUNC(column|expression,
n) -Truncates the column, expression, or value to n decimal places
or, if n is omitted, n defaults to zero
MOD(m,n) -Returns the remainder of m
divided by n
CEIL FLOOR MOD |
ROUND |
TRUNC |