7.182 REMAINDER
Syntax
Purpose
REMAINDER
returns the remainder of n2
divided by n1
.
This function takes as arguments any numeric data type or any nonnumeric data type that can be implicitly converted to a numeric data type. Oracle determines the argument with the highest numeric precedence, implicitly converts the remaining arguments to that data type, and returns that data type.
The MOD
function is similar to REMAINDER
except that it uses FLOOR
in its formula, whereas REMAINDER
uses ROUND
. Refer to MOD.
See Also:
Table 28 for more information on implicit conversion and "Numeric Precedence" for information on numeric precedence

If
n1
= 0 orn2
= infinity, then Oracle returns
An error if the arguments are of type
NUMBER

NaN
if the arguments areBINARY_FLOAT
orBINARY_DOUBLE
.


If
n1
!= 0, then the remainder isn2
 (n1
*N
) whereN
is the integer nearestn2
/n1
. Ifn2
/n1
equalsx.5
, thenN
is the nearest even integer. 
If
n2
is a floatingpoint number, and if the remainder is 0, then the sign of the remainder is the sign ofn2
. Remainders of 0 are unsigned forNUMBER
values.
Examples
Using table float_point_demo
, created for the TO_BINARY_DOUBLE
"Examples", the following example divides two floatingpoint numbers and returns the remainder of that operation:
SELECT bin_float, bin_double, REMAINDER(bin_float, bin_double) FROM float_point_demo; BIN_FLOAT BIN_DOUBLE REMAINDER(BIN_FLOAT,BIN_DOUBLE)    1.235E+003 1.235E+003 5.859E005