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.