# Oracle/PLSQL: MOD Function

Learn how to use the Oracle/PLSQL **MOD function** with syntax and examples.

## Description

The Oracle/PLSQL **MOD function** returns the remainder of *m* divided by *n*.

## Syntax

The syntax for the Oracle/PLSQL **MOD function** is:

MOD( m, n )

### Parameters or Arguments

The MOD is calculated as:

m - n * floor(m/n)

## Note

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.

## Applies To

The MOD function can be used in the following versions of Oracle/PLSQL:

- Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i

## Example

Let's look at some Oracle MOD function examples and explore how to use the MOD function in Oracle/PLSQL.

For example:

MOD(15, 4) | would return 3 |

MOD(15, 0) | would return 15 |

MOD(11.6, 2) | would return 1.6 |

MOD(11.6, 2.1) | would return 1.1 |

MOD(-15, 4) | would return -3 |

MOD(-15, 0) | would return -15 |