Oracle REMAINDER function.

Preamble

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

Oracle/PLSQL syntax of REMAINDER function

REMAINDER( m, n )

Parameters and function arguments

• m – is the numeric value used in the calculation.
• n – numeric value used in the calculation.

REMAINDER is calculated as:

m – (n * X)
X next integer m / n

The REMAINDER function returns a numeric value.

The REMAINDER function can be used in the following Oracle/PLSQL versions

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

SELECT REMAINDER(15, 6) FROM DUAL;

--Result: 3

SELECT REMAINDER(15, 5) FROM DUAL;

--Result: 0

SELECT REMAINDER(15, 4) FROM DUAL;

--Result: -1

SELECT REMAINDER(11.6, 2) FROM DUAL;

--Result: -0.4

SELECT REMAINDER(11.6, 2.1) FROM DUAL;

--Result: -1

SELECT REMAINDER(-15, 4) FROM DUAL;

--Result: 1

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.