I don't think the use of the upper function is a good idea for queries.
If the field is indexed Oracle won't be able to use the index in your query
(unless you had created a function based index...)

--Claudio


On Tue, 27 Feb 2007 08:17:30 -0600, Panagopoulos Chris wrote
> One way I use are with the upper/lower functions, i.e.
> Where upper(field) = upper(xxxx)
>
> -----Original Message-----
> From: Darren Nye
> [mailto:oracledba-ezmlmshield-x8803743.[Email address protected]
> Sent: Tuesday, February 27, 2007 8:05 AM
> To: LazyDBA Discussion
> Subject: case insensitive!
>
> hello there, I really need to get oracle to perform case insensitive
> searches,
>
> I know that if you type
>
> alter session set nls_comp=ansi;
> alter session set nls_sort=binary_ci;
>
> then it will perform case insensitive searches, but that's only for that
> current session, is there a way to alter it for a particular user?
>
> please help ive been stuck on this for hours!
>
> thanks
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
> This message (including any attachments) is confidential and
> intended solely for the use of the individual or entity to whom it
> is addressed, and is protected by law. If you are not the intended
> recipient, please delete the message (including any attachments) and
> notify the originator that you received the message in error. Any
> disclosure, copying, or distribution of this message, or the taking
> of any action based on it, is strictly prohibited. Any views
> expressed in this message are those of the individual sender, except
> where the sender specifies and with authority, states them to be the
> views of Vanguard Health Systems.
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html


Oracle LazyDBA home page