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.