rsastry
asked on
Case insensitive search in Oracle
I know string data comparision in Oracle is case sensitive. Is there a way where can eliminate case sensitive compariision? (we are using 9i)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Well, if you don't want to touch the code you could always create triggers
create or replace trigger on trg_my_table
before insert or update on my_table
for each row
begin
:new.Col1 := upper(:new.Col1);
end;
/
create or replace trigger on trg_my_table
before insert or update on my_table
for each row
begin
:new.Col1 := upper(:new.Col1);
end;
/
Yes, you are looking for a feature that SQL Server has (I believe), but unfortunately for you, Oracle does not.
ASKER