turn off/on case insensetive search in Oracle DBMS

Hello,

we want to do some SQL-statement like 'SELECT FROM table WHERE field1 = "name"' not be affected by case sensitivity as in result we get "name" or "Name". Our actual installation of Oracle 8 works case sensitive.

My DBA for our Oracle 8 DBMS told me, that it isn't possible to change this at the server site to "case insensitive".

A developer told me, he had read that the server site is configurable for "case insensitive" or "case sensitive" (what we have at the moment).

My question: Who is right?

Thanks for help
Bernd.

-- 
Bernd F. Dollinger
eMail: Bernd.Dollinger_at_dv-werk.de