Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Q: invalid table name "orders" ?
Reserved words, such as "order", "select", "insert", etc. are not valid table names.
In article <7u2dm5$vjl$1_at_nnrp1.deja.com>,
tedchyn_at_yahoo.com wrote:
> Sir: has any body seen this ? order is invalid table name and orders
is
> valid table name. I tried this in nt and solaris and got the same
error
> message.
>
> thanks in advance, ted chyn(tedchyn_at_yahoo.com)
>
> SQL> create table order(c1 varchar2(3));
> create table order(c1 varchar2(3))
> *
> ERROR at line 1:
> ORA-00903: invalid table name
>
> SQL> c/der/ders/
> 1* create table orders(c1 varchar2(3))
> SQL> /
>
> Table created.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Oct 13 1999 - 12:46:05 CDT