Oracle PLSQL: Remainder Function

In Oracle/PLSQL, the remainder function returns the remainder of m divided by n.

Syntax

The syntax for the remainder function is:

remainder( m, n )

The remainder is calculated as:

m - (n * X) where X is the integer nearest m / n

Note

The remainder function uses the round function in its formula, whereas the mod function uses the floor function in its formula.

Applies To

• Oracle 11g, Oracle 10g

For Example

remainder(15, 6)	would return 3
remainder(15, 5)	would return 0
remainder(15, 4)	would return -1
remainder(11.6, 2)	would return -0.4
remainder(11.6, 2.1)	would return -1
remainder(-15, 4)	would return 1