MOD returns the remainder of the first argument divided by the second argument.

The arguments can be a numeric value or any type that can be implicitly converted to a numeric value.

Oracle will determine the argument with the highest numeric precision and convert all the calculations and result to that level.

Syntax:

MOD(n,n2)

Example:

SELECT MOD(10,3) as mod_result FROM DUAL;

MOD_RESULT
———————
1

Example

Mod – Oracle SQL Function
Tagged on: