Im using Oracle 11g, and i have a query like
select * from test where ID_PRIVILEGES = 'ADMIN';
but in database ID_PRIVILEGES is stored as Admin, I want case insensitive search to be done. I cannot change my query as
select * from test where ID_PRIVILEGES = 'Admin';
Can anyone please help.