Re: Column name to lowercase?

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Mon, 10 Feb 2003 08:57:05 -0800
Message-ID: <3E47D9E1.F3993BD7@exesolutions.com>

Andreas Schlegel wrote:

> 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

Unless you are a masochist what possible rational reason could you have for wanting to do this?

The good news is that you can't. The bad news is that you can manually work around it using double-quotes.

Why would you want to sabotague the data dictionary and make every single SQL statement a nightmare? Trying to cripple Oracle and turn it into SQL Server?

Daniel Morgan Received on Mon Feb 10 2003 - 10:57:05 CST