Re: Columns names and USER_TAB_COLUMNS

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Sat, 27 Nov 1999 03:36:23 GMT
Message-ID: <38545129.69774820@netnews.worldnet.att.net>

On Thu, 25 Nov 1999 02:27:30 -0800, Alex Vinokur <alexander.vinokur_at_telrad.co.il> wrote:

>1. Can *names of columns of user-defined tables*
> contain lower-case letters?
> I think, most likely, an answer is negative.

Table and column names may contain lower-case letters, but you have to enclose the column names in quotes. For example:

        create table x ("y" number);

I don't recommend this as it will confuse the heck out of your programmers, force them to quote everything, and you may run into some tools that don't recognize what you are doing .

>
>2. Can a user add additional columns
> to the table USER_TAB_COLUMNS?
> Is an answer negative?

No. USER_TAB_COLUMNS is a data dictionary view, and you shouldn't touch it. I suppose that you could recreate the view with different columns, but I don't think you could add any to the underlying data dictionary tables.

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are Received on Fri Nov 26 1999 - 21:36:23 CST