Oracle MOD function.

Preamble

Oracle/PLSQL MOD function returns the residue from division m by n.

Oracle/PLSQL syntax of the MOD function

MOD( m, n )

Parameters and function arguments

• MOD is calculated as: m – n * floor(m/n)

Note:

• The MOD function uses the FLOOR function in this formula.
• The MOD function returns a numeric value.
• The MOD function returns m if n=0.

MOD function in the following Oracle/PLSQL versions

Let’s consider some examples of MOD function and learn how to use MOD function in Oracle/PLSQL.

SELECT MOD(15, 4) FROM DUAL;

--Result: 3

SELECT MOD(15, 0) FROM DUAL;

--Result: 15

SELECT MOD(11.6, 2) FROM DUAL;

--Result: 1.6

SELECT MOD(11.6, 2.1) FROM DUAL;

--Result: 1.1

SELECT MOD(-15, 4) FROM DUAL;

--Result: -3

SELECT MOD(-15, 0) FROM DUAL;

--Result: -15

About Enteros

​​​Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.​