Oracle PL/SQL Remainder Function

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

The Remainder Function syntax:

remainder( a, b )

a – (b * X) where X is the integer nearest a / b

Example

Select remainder(10,3) From dual;

1


Select remainder(9,3) From dual;

0


Select remainder(15,4) From dual;

-1


Select remainder(-15,4) From dual;

1