Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The MODULO function, like the SQL MOD
function, returns the remainder after a number is divided by another; or the number if the divisor is 0 (zero).
Numeric.
Oracle determines the argument with the highest numeric precedence, implicitly converts the remaining arguments to that data type, and returns that data type
MOD(dividend, divisor)
A numeric expression (or an expression that Oracle OLAP can implicitly convert to a numeric expression) that is the number you want to divide.
A numeric expression (or an expression that Oracle OLAP can implicitly convert to a numeric expression) that is the divisor.