Re: Oracle 12c Case insensitive searches

From: Zahir Mohideen <zahir.dba_at_gmail.com>
Date: Wed, 4 Apr 2018 12:19:03 -0400
Message-ID: <CAM5KiKrPC9F-9vh4ZMLRupAnV7im5+SkSOnS-h9K05c=FcRLsQ_at_mail.gmail.com>



You can set the nls settings , perform the case insensitive search.

http://mfzahirdba.blogspot.com/2010/04/case-sensitiveness.html

  • Zahir

Zahir Mohideen
http://mfzahirdba.blogspot.com/

*Nothing so GREAT was achieved without enthusiasm*

On Tue, Apr 3, 2018 at 5:36 PM, Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> Better how? What aspect of case insensitive search needs improvement?
>
> On 04/03/2018 11:37 AM, Sanjay Mishra (Redacted sender smishra_97 for
> DMARC) wrote:
>
> Is there any good solution for Case insensitive search to one or two col
> level on table ? Is any new featured added in any 12c flavor that provide
> better solution over old Index/Function based Index/Context index ?
>
> TIA
> Sanjay
>
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 04 2018 - 18:19:03 CEST

Original text of this message