Re: Oracle case in sensitive

Hi,

I think of two possible ways:

1.: always use column = UPPER(value) in your queries.

2.: if you are using SQL*Plus you can use SET SQLCASE UPPER as environment, which will translate all your stuff to uppercase. To handle this for all your private session add this statement to your $ORACLE_HOME/DBS/LOGIN.SQL file, which is read by SQL*Plus on startup.

Hope this helps.

Martin

In article <911t35$m0t$1_at_nnrp1.deja.com>,   sundarkumar_at_my-deja.com wrote:
> Hi Everyone
>
> I want to make oracle case insensitive meaning, if I fire a sql query
> like
>
> Ex : select * from customers where some_value=some_case_sensitive;
>
> So this query will pick up only the matched some_case_sensitive value.
 I
> don't want it to be checked for case sensitives.
>
> Ex "junk"="JUNK" - this data not get returned if I fire the above sql
> becoz by default sql will pickup the exact match value. I don't want
> this should not be checked. If I looking for junk, it
> should take all junk case in sensitive values and return it to me.
>
> I am sure there is some parameter to set and achieve this. Pls help me
> out in this issues...
>
> Thanx in Advance...
>
> Sundar
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 11 2000 - 01:21:35 CST