Learn how to use the Oracle/PLSQL MOD function with syntax and examples.
The Oracle/PLSQL MOD function returns the remainder of m divided by n.
The syntax for the Oracle/PLSQL MOD function is:
MOD( m, n )
The MOD is calculated as:
m - n * floor(m/n)
The MOD function uses the floor function in its formula, whereas the REMAINDER function uses the ROUND function in its formula.
The MOD function returns m if n is 0.
The MOD function can be used in the following versions of Oracle/PLSQL:
Let's look at some Oracle MOD function examples and explore how to use the MOD function in Oracle/PLSQL.
MOD(15, 4) Result: 3 MOD(15, 0) Result: 15 MOD(11.6, 2) Result: 1.6 MOD(11.6, 2.1) Result: 1.1 MOD(-15, 4) Result: -3 MOD(-15, 0) Result: -15