Mega Code Archive

 

Categories / Oracle PLSQL / Numeric Math Functions

 

MOD() returns the remainder of numeric_expression1 divided by numeric_expression2

SQL> Syntax: MOD(<numeric_expression1>,<numeric_expression2>) SQL> SQL> SQL> SELECT   2     MOD(10,5) remainder1,   3     MOD(10,3) remainder2 from dual; REMAINDER1 REMAINDER2 ---------- ----------          0          1