Re: Columns names and USER_TAB

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 26 Nov 1999 15:24:05 GMT
Message-ID: <81m8ml$hhh$1@news.seed.net.tw>

Alex Vinokur <alexander.vinokur_at_telrad.co.il> wrote in message news:04a61603.76aaf52c_at_usw-ex0109-069.remarq.com...
>
> 1. Can *names of columns of user-defined tables*
> contain lower-case letters?
> I think, most likely, an answer is negative.

Yes, you can.
You can enclosed the name in double quotation marks.

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

Yes, you can.
USER_TAB_COLUMNS is a view for public.
You can create a "private" version view, or if you have the privilege, you can replace the definition of the view to add new columns. But, it is not recommended. Received on Fri Nov 26 1999 - 09:24:05 CST

Re: Columns names and USER_TAB_COLUMNS