try it with a logon-trigger for the particular user.
in this you can do

...
execute immediate 'alter session set nls_comp=ansi';
execute immediate 'alter session set nls_sort=binary_ci';
...

hth
Rüdiger J. Schulz
sosys-berlin.de

On Tue, 27 Feb 2007 08:17:30 -0600, Panagopoulos Chris
<oracledba-ezmlmshield-x77047409.[Email address protected] 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