column name [message #3451] |
Fri, 27 September 2002 11:15 |
Mitra
Messages: 11 Registered: April 2002
|
Junior Member |
|
|
Hi Everyone,
Can some one tell why i don't have any problem to create a table with column name 'size' using Oracle EM Create Table menu and/or Table wizard but if i want to create the same table with the same column name using SQL*PLUS i get the ORA-00904: invalid column name ERROR.
Thanks for your help!
Mitra
|
|
|
Re: column name [message #3453 is a reply to message #3451] |
Fri, 27 September 2002 13:45 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
Because EM is double-quoting the column name:
sql>create table t (size int);
create table t (size int)
*
ERROR at line 1:
ORA-00904: invalid column name
sql>create table t ("SIZE" int);
Table created.
Even though the double-quote option allows the column, it is not a good idea to name any object with a reserved name.
|
|
|