Vamos la no exemplo:
SQL> create table test_sort (f varchar2(50));
SQL> insert into test_sort values (‘&valor’);
Valor teste 1
vAlOr Teste 2
VALOR teste 3
SQL> select *
from test_sort
where f like ‘Valor%’;
F
Valor teste 1
SQL> alter session set nls_comp=’LINGUISTIC’;
SQL> alter session set NLS_SORT=’BINARY_CI’;
SQL> select *
from test_sort
where f like ‘Valor%’;
F
Valor teste 1
vAlOr Teste 2
VALOR teste 3
[]