Xref: alice comp.databases.oracle.server:75726
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!wn4feed!worldnet.att.net!wnmaster1!not-for-mail
From: jonathan@gennick.com (Jonathan Gennick)
Newsgroups: comp.databases.oracle.server
Subject: Re: Columns names and USER_TAB_COLUMNS
Date: Sat, 27 Nov 1999 03:36:23 GMT
Organization: AT&T WorldNet Services
Lines: 33
Message-ID: <38545129.69774820@netnews.worldnet.att.net>
References: <04a61603.76aaf52c@usw-ex0109-069.remarq.com>
Reply-To: jonathan@gennick.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: bgtnsc03.worldnet.att.net 943674003 18407 12.67.148.35 (27 Nov 1999 03:40:03 GMT)
X-Complaints-To: abuse@worldnet.att.net
NNTP-Posting-Date: 27 Nov 1999 03:40:03 GMT
X-Newsreader: Forte Agent 1.5/32.452

On Thu, 25 Nov 1999 02:27:30 -0800, Alex Vinokur
<alexander.vinokur@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@gennick.com   
http://gennick.com
Brighten the Corner Where You Are