Re: Column name to lowercase?

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Mon, 10 Feb 2003 09:58:43 -0800
Message-ID: <3E47E853.A595F19B@exesolutions.com>

Andreas Schlegel wrote:

> DA Morgan wrote:
> >
> > Unless you are a masochist what possible rational reason could you have
> > for wanting to do this?
> No, I am really not a masochist and so I already decided not to go this
> way ;-)
> It is quite the opposite. I am completely lazy and so I looked for the
> cheapest and easiest way to make an existing app runable on Oracle (as
> I mentioned earlier)
>
> Greetings,
> Andreas

No Oracle app could possibly require lower-case object names. If you somehow have one I'd remove it from the system and smash the CD.

The basic assumption in the Oracle data dictionary is that all object names are upper case. While Oracle allows lower case and mixed case to be used (I wish they didn't) it can only break things or make all coding a nightmare.

Daniel Morgan Received on Mon Feb 10 2003 - 11:58:43 CST