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