Re: Column name to lowercase?

From: Gernot Ficker <gernot_ficker_at_hotmail.com>
Date: Mon, 10 Feb 2003 14:00:14 +0100
Message-ID: <b287of$f5u$05$1@news.t-online.com>

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 - 07:00:14 CST