Re: Columns names and USER_TAB_COLUMNS

Hi ALex,

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

Oracle treats all key words and names case insensitive, i.e. converts to uppercase.

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

USER_TAB_COLUMNS is a complex view. There is neither a need nor a way to modify it.

Regards

--
uwe.schneider_at_xlink.net Received on Thu Nov 25 1999 - 08:57:43 CST