Re: invalid table name "orders" ?

order is a reserved word. Compare order by

Hth,

--
Sybrand Bakker, Oracle DBA
<tedchyn_at_yahoo.com> wrote in message news:7u2dm5$vjl$1_at_nnrp1.deja.com...
> 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.
Received on Wed Oct 13 1999 - 12:18:40 CDT