Re: Case insensitive queries

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Sun, 23 Nov 2003 22:09:25 GMT
Message-ID: <3FC13015.9B0BA439@yahoo.net>

JB wrote:
>
> How can one set the Oracle database in case insensitive query mode?
> How can this be done globally(always) as well as per query and per
> session? All three please!
>
> Thanks!

AFAIK, data is case sensitive. AFAIK, you can not force Oracle to set case insensiivity using some instance/database/session poarameter.

Per query, you can force case-matching using the 'lower()' and 'uppper()' functions against both sides of the condition.

Opinion: I'm not sure that I'd want to be able to have a global- or session- based case insensitivity. Seems to me there'd be too many exceptions where I'd want the other way. (Seems to me the requirement for case-insensitivity would be a generated by programmer laziness or insufficient user training - not uncommon these days.) Received on Sun Nov 23 2003 - 16:09:25 CST