REMAINDER
The REMAINDER function returns the remainder when one number is divided by another.
Return Values
Numeric. Oracle OLAP determines the argument with the highest numeric precedence, implicitly converts the remaining arguments to that data type, and returns that data type.
Syntax
REMAINDER (diviidend, divisor)
Parameters
- dividend
-
A numeric expression (or an expression that Oracle OLAP can implicitly convert to a numeric expression) that is the number you want to divide.
- divisor
-
A numeric expression (or an expression that Oracle OLAP can implicitly convert to a numeric expression) that is the divisor.
Examples
Example 8-70 Finding the Remainder After Division
SHOW REMAINDER(18,7)
-3.00
