We help IT Professionals succeed at work.

Difference between modulus functions in oracle

sam_2012
sam_2012 asked
on
Hi Team,

I would like to know the difference between Remainder and Mod function in Oracle ,as both are used to evaluate the remainder of a division operation.
Comment
Watch Question

Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
Have you looked up both functions in the online documentation?

It explains the difference:
https://docs.oracle.com/database/122/SQLRF/REMAINDER.htm#SQLRF06312
The MOD function is similar to REMAINDER except that it uses FLOOR in its formula, whereas REMAINDER uses ROUND.