| Muks |
Posted: Apr 29, 2008 03:00:26 AM |
Total Post: 47
Joined: Jan, 2007
|
Hi
How do I create a table with numeric columns like 1000, 2000...
Besties
|
|
|
 http://shaharear.blogspot.com |
| Posted: Apr 29, 2008 03:26:50 AM |  |
|
Total Post: 135
Joined: Apr, 2008
|
you can not use 100 as column name .. a column name must start with lettet
create table test ( A20 number(4));
Table created.
SQL> drop table test purge;
Table dropped.
SQL> create table test ( 100 number(4));
create table test ( 100 number(4))
*
ERROR at line 1:
ORA-00904: : invalid identifier
SQL> create table test ( '100' number(4));
create table test ( '100' number(4))
*
ERROR at line 1:
ORA-00904: : invalid identifier
|
|
|
|
|
| Gitesh |
| Posted: Apr 29, 2008 06:50:05 AM | |
|
Total Post: 322
Joined: May, 2005
|
There are certain rules for giving object name and column name in oracle.Check oracle limitation in oracle documents.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
