Re: [URGENT] Case sensitive

I assume your problem is that you want

select * from tab where name like 'Jinib'; to be treated in the same way as
select * from tab where name like 'JINIB'; ?

If this is the case then you can do one of two things.

1. Create an extra column and store the column values in upper (or lower) case, you can poulate this by means of triggers. Then rewrite your sql to use the upper case column.
2. create a function based index on the column and query using the function. this is an 8iEE or higher option only.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"Jinib" <jinib_at_caramail.com> wrote in message
news:a967jr$gci$1_at_s1.read.news.oleane.net...


> Hi everybody,

>

> I must change the 'case sensitive' to 'case unsensitive' on an oracle

> database with Sun Solaris 8.

>

> Can you help me please ??

>

> Thanks for your answer.

>

>