REMAINDER function returns the remainder of a number divided by another number.

Syntax:

select REMAINDER(m,n) from dual;

It is the mathematical expression m / n (m divides n).

Examples :-

1) select REMAINDER(5,3) from dual;

REMAINDER(5,3)
———————-
2

2) select REMAINDER(6,0) from dual;

The above statement will raise an error as divisor is equal to zero. Mathematically division by zero is undefined or infinity.

2) select REMAINDER(3,5) from dual;

REMAINDER(3,5)
———————-
-2

Some more examples

REMAINDER(5,2)	1
REMAINDER(5,0)	ERROR
REMAINDER(5,5)	0
REMAINDER(2,5)	-3
REMAINDER(-2,5)	-2
REMAINDER(5,-1)	0
REMAINDER(5,0.5)	0
REMAINDER(5,1.2)	0.2

REMAINDER function introduced in Oracle 10g version.