Does any body know how to make a UNIQUE constraint case insensitive.
For example, I create a table like:
create table test (str varchar2(10) unique);
insert into test values ('abc');
insert into test values ('Abc');
I hope that the second insert above would suffer a unique constraint violated error.
Thanks for any help.