Remainder – Oracle SQL Function

REMAINDER returns the remainder of the 1st argument divided by the 2nd argument.

Remainder is similar to MOD except thaqt REMAINDER uses ROUND in its calculations, whereas MOD uses FLOOR.

Example:

SELECT REMAINDER(10,3) as remainder_value from dual;

REMAINDER_VALUE
——————————–
1