posted 19 years ago
I think you've misunderstood the Oracle documentation; you can understand "between" to mean "greater than or equal to the first value, and less than or equal to the second". So:
means that the value of <param> is any value in the set {1, 2, 3, 4, 5, 6, 7, 8, 9, 10}.
An result of this is that the between comparison operator implicitly requires ordering. If I wrote it the other way:
This would only return true if the value of <param> was not in the set {2, 3, 4, 5, 6, 7, 8, 9}.
[ January 17, 2005: Message edited by: Paul Sturrock ]
[ January 17, 2005: Message edited by: Paul Sturrock ]