Re: How configure Oracle 9i not case sensitive...

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 23 Apr 2004 06:49:56 -0700
Message-ID: <1082728188.674512@yasure>

D Rolfe wrote:

> Eloy,
> 

>> Hi, i would configure Oracle 9i not case sensitive and in the table names
>> dont use ""...
>>
>> How can i do this ?
>>
>> Thanks in advance
>>

And now that others have told you how to do it I will try to persuade you to change your mind and not do so.

Reason:

1. It is unnecessary
2. It is inconvenient
3. Almost all third-party tools will not work with the mixed-case names which means report writers, query tools, case tools, etc.
4. If you get used to this skill and go to a company that follows good development standards they will either force you to stop or fire you.

I'd suggest you do it right, use the default, and not try to foist your habits from another product onto Oracle.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Fri Apr 23 2004 - 08:49:56 CDT