Hi ALL!
I have problem with CASE SENSITIVE in data. For example,
when i give my request:
SELECT * FROM table_name WHERE column1 LIKE 'value1'
This request gives results different from the ones given by the request:
SELECT * FROM table_name WHERE column1 LIKE 'Value1'
The solution to solve CASE SENSITIVE is to use UPPER:
SELECT * FROM table_name WHERE UPPER(column1) LIKE UPPER('value1')
But i would like to know how to configure ORACLE so that we don't need
to user
the operator UPPER in requests.
Thank for help.