Re: Case sensitive

From: HansF <News.Hans_at_telus.net>
Date: Wed, 29 Jun 2005 14:29:50 GMT
Message-Id: <pan.2005.06.29.14.33.10.808973@telus.net>

On Wed, 29 Jun 2005 04:35:20 -0700, daniellopez21 interested us by writing:

> I have problem with "case sentitive" in Oracle.
>
> When I use the UPPER function, sql statment not acces by index.
>
> How I can disable de "case sensitive" of oracle

Learn about 'Function Based Indexes'.

(Also realize that using an index is not always the best, or fastest, way of getting data.)

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***

Received on Wed Jun 29 2005 - 09:29:50 CDT