Função Oracle MOD

-- CALCULA RESTANTE DA DIVISÃO

SELECT last_name, salary, MOD(salary, 5000)
  FROM hr.employees
 WHERE employee_id IN (150, 174, 176, 178);

SELECT MOD(10,2)
  FROM dual;

SELECT MOD(14,3)
  FROM dual;

SELECT FLOOR (14/3)
  FROM dual;

SELECT (14 - (3 * FLOOR(14/3)))
  FROM dual;