Hi All,
Can anyone explain the difference between mod & remainder functions in oracle.
Example1 :
Remainder :
SELECT remainder(37,5) as remainder FROM DUAL;
O/P : 2
Mod :
SELECT mod(37,5) as mod FROM DUAL;
O/P : 2
Example2 :
Remainder :
SELECT remainder(20,3) as remainder FROM DUAL;
O/P : -1
Mod :
SELECT mod(20,3) as mod FROM DUAL;
O/P : 2
From the above examples i could not able to understand the remainder function.
Thanks,
Hanu