Re: Columns names and USER_TAB_COLUMNS

>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 use all characters but you'll have to use double-quotes

create table "test table 12343^&**"
("LOWER / uppercase " number);

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

_Nobody_ should use DML statements on dictionary views.

Rob Received on Thu Nov 25 1999 - 09:52:53 CST