MODULO function returns the remainder value when a number (Dividend) is divided by another number (divisor).

Format: MOD (dividend, divisor).

Example1:

SELECT MOD (100, 9) FROM DUAL;

Result: 1

Example2:

SELECT MOD (-100, 9) FROM DUAL;

Result: -1