MODULO

Posted by Phani Adivi on October 30, 2018 in Oracle Home

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;

1	SELECT MOD (100, 9) FROM DUAL;

Result: 1

Example2:

SELECT MOD (-100, 9) FROM DUAL;

1	SELECT MOD (-100, 9) FROM DUAL;

Result: -1