Number Functions

Characteristics

You use number functions to accept numeric input. The number functions return numeric values.

Function Names

The three most commonly used number functions are the following:

• ROUND: Rounds a column, an expression, or a value to n decimal places
• MOD: Returns the remainder of x divided by y
• TRUNC: Truncates a column, an expression, or a value to n decimal places