On Sat, 29 Nov 2003, damorgan_at_x.washington.edu wrote:
> Galen Boyer wrote:
>>>And which part of UPPER(x) = UPPER(y) is to radical to
>>>consider?
>> None. But having to do this is a workaround. Simple. What
>> about that is hard to consider?
>
> But a switch in the init.ora that does the same thing isn't?
> The code above will run on any version of Oracle going back to
> the stone age. The code you write dependent on the switch will
> work only if on 10g.
But upper(x) = upper(y) only works when you want
case-insensitive. What if you now need case-sensitive? That
query won't work. So, it is two queries. With Oracle's help, we
could have just one query to solve both questions.
--
Galen Boyer
Received on Sat Nov 29 2003 - 17:17:08 CST
