Connected to:
Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production

SQL> create table brisime (col varchar2(20));

Table created.

SQL> insert into brisime values ('Little Foot');

1 row created.

SQL> insert into brisime values ('LITTLE foot');

1 row created.

SQL> insert into brisime values ('little FOOT');

1 row created.

SQL> select * from brisime;

COL
--------------------
Little Foot
LITTLE foot
little FOOT

SQL> alter session set nls_comp = ANSI;

Session altered.

SQL> alter session set nls_sort = GENERIC_BASELETTER;

Session altered.

SQL> select * from brisime where col = 'little foot';

COL
--------------------
Little Foot
LITTLE foot
little FOOT

SQL>