Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 70 of 166
mod::=
mod
MOD
returns the remainder of m divided by n. Returns m if n is 0.
The following example returns the remainder of 11 divided by 4:
SELECT MOD(11,4) "Modulus" FROM DUAL; Modulus ---------- 3
This function behaves differently from the classical mathematical modulus function when m is negative. The classical modulus can be expressed using the MOD
function with this formula:
m - n * FLOOR(m/n)
The following table illustrates the difference between the MOD
function and the classical modulus:
M | N | MOD(M,N) | Classical Modulus |
---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|