Re: turn off/on case insensetive search in Oracle DBMS

On Fri, 27 Jul 2001 12:18:29 -0700, "Daniel A. Morgan" <Daniel.Morgan_at_attws.com> wrote:

>
>I read this question very differently than you did. Turning off a search I
>interpreted as being a "switch" that could be flicked back and forth at will. A
>function based index will solve the problem. But you'll need to drop and rebuild
>the index to reverse it.
>

You can of course build the function-based index and then elect to not use it? By using something else (concat of null or equivalent) to stop use of the index or nothing to use it. Works for me, best of both worlds too.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Sat Jul 28 2001 - 05:01:51 CDT