REMAINDER

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

REMAINDER(m,n)

Example 1:

SELECT REMAINDER(15,6) FROM DUAL;

returns:

3

Example 2:

SELECT REMAINDER(-15,4) FROM DUAL;

returns:

1

Example 3:

SELECT REMAINDER(15,4) FROM DUAL;

returns:

-1