Sunday, January 31, 2010

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

No comments:

Post a Comment