Re: Column name to lowercase?

From: Andreas Schlegel <schlegelaw_at_epost.de>
Date: Mon, 10 Feb 2003 15:14:19 +0100
Message-ID: <3E47B3BB.6090806@epost.de>

Hi Gernot,

well that is true if we look only on SQL. But we have an app that runs up to now only on SQL Server. We implemented all column, table and view names in lower-cases. To make this app ready to run with Oracle it would be the best if could implement the object names in lower-cases, too.

But the result of my research is: there is no change to get this implementation on Oracle. So we close this thread. Thanks for answer.

Greetings,
Andreas

Gernot Ficker wrote:

> Hi Andreas,
> 
> column names in Oracle are not case sensitive as long as you don't use double quotes.
> You can use lower (or mixwd) case in your queries.
> 
> Gernot
> 
> "Andreas Schlegel" <schlegelaw_at_epost.de> schrieb im Newsbeitrag
> news:3E478718.9040701_at_epost.de...
> 

>>Hi,
>>
>>looking for a solution to set Orcale default for column names from
>>uppercase to lowercase.
>>
>>Of course, I may Oracle to accept lower-case names for tables and
>>columns by using double-quotes. But that causes a problem with the
>>Oracle data dictionary. Every time I reference this columns I have to
>>use the double-quotes.
>>
>>So my question is: is there any other change to let Oracle run with
>>lowercase column names?
>>
>>I am using Oracle 8.1.7
>>
>>Greetings,
>>Andreas
>>

> 
> 
> 

Received on Mon Feb 10 2003 - 08:14:19 CST