MOD is one of the vital Numeric/Math functions of Oracle. It is used to get the remainder of x divided by y. The MOD function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i.
Syntax:
MOD ( x, y )
Parameters:
x, y: They are used to specify the numbers to be used for calculation.
Example 1:
MOD (10, 2) |
Output:
0
Explanation:
The MOD is calculated as [x – (y * floor (x/y))].
Example 2:
MOD (10, 3) |
Output:
1
Explanation:
The MOD is calculated as [x – (y * floor (x/y))].
Example 3:
MOD (10.5, 3) |
Output:
1.5
Explanation:
The MOD is calculated as [x – (y * floor (x/y))].