Oracle case in sensitive

From: <sundarkumar_at_my-deja.com>
Date: Mon, 11 Dec 2000 06:43:50 GMT
Message-ID: <911t35$m0t$1@nnrp1.deja.com>

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. Received on Mon Dec 11 2000 - 00:43:50 CST