Tag: REMAINDER function

• December 11, 2011

  Oracle REMAINDER function

  REMAINDER function returns the remainder of a number divided by another number. Syntax: select REMAINDER(m,n) from dual; It is the mathematical expression m / n (m divides n). Examples :- 1) select REMAINDER(5,3) from dual; REMAINDER(5,3) ———————- 2 2) select REMAINDER(6,0) from dual; The above statement will raise an error as divisor is equal to zero. […]