Oracle PL/SQL Mod Function

The Mod function returns the remainder of a divided by b.

The Mod Function syntax:

mod( a, b )

a – b * floor(a/b)

Example

Select mod(17,5) From dual;
2

Select mod(17,0) From dual;
17

Select mod(17.3,2) From dual;
1.3

Select mod(17.3,2.1) From dual;
0.5

Select mod(-17,5) From dual;
-2

Select mod(-17,0) From dual;
-17