Aw: Oracle 12c Case insensitive searches

From: Michael D O'Shea/Woodward Informatics Ltd <>
Date: Tue, 3 Apr 2018 16:44:53 +0100
Message-Id: <>

Not sure whether I am missing the point of the post Sanjay but perhaps

caseInsensitiveVC2 varchar2(nn) generated always as lower(xxx) virtual

And a normal index on caseInsensitiveVC2 and queries always in lower

Any good?


Dr. Michael D. O’Shea, <> Woodward Informatics Ltd, <> +44 (0)7402 851508

> Am 03.04.2018 um 16:37 schrieb Sanjay Mishra (Redacted sender "smishra_97" for DMARC) <>:
> 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 ?
> Sanjay

Received on Tue Apr 03 2018 - 17:44:53 CEST

Original text of this message