REMAINDER is one of the vital Numeric/Math functions of Oracle. It is used to get the remainder of x divided by y. The REMAINDER function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g and Oracle 10g.

**Syntax: **

REMAINDER ( x, y )

** Parameters: **

**x, y: ** They are used to specify the numbers to be used for calculation.

** Example 1: **

REMAINDER (10, 2)

**Output: **

0

**Explanation: **

The REMAINDER is calculated as [x – (y * n)], where n is the integer nearest to (x/y), here n = 5.

** Example 2: **

REMAINDER (10, 3)

**Output: **

1

**Explanation: **

The REMAINDER is calculated as [x – (y * n)], where n is the integer nearest to (x/y), here n = 3.

** Example 3: **

REMAINDER (10, 6)

**Output: **

-2

**Explanation: **

The REMAINDER is calculated as [x – (y * n)], where n is the integer nearest to (x/y), here n = 2.