Real Number Comparator (nR)
The Real Number Comparator function matches specifically on real numbers based on the logic described above. It accepts the parameters listed in the following table.
Table 8 nR Comparison Function Parameters|
Parameter |
Description |
|---|---|
|
Specifies whether a relative distance calculation or a direct string comparison is used. Specify “y” to use a relative distance calculation; specify “n” to use a string comparison. |
|
|
range |
The greatest difference between two integers at which the values could still be considered a possible match. When the difference between two numbers is greater than the relative distance, the numbers are considered a non-match (the weight becomes zero when the actual difference is the relative distance plus one). |
- © 2010, Oracle Corporation and/or its affiliates