MOD

The Oracle and PL/SQL MOD function returns the remainder of m divided by n.

MOD(m,n)

Example 1:

SELECT MOD(13,5) FROM DUAL;

returns:

3

Example 2:

SELECT MOD(-11,4) FROM DUAL;

returns:

-3