Re: Q: invalid table name "orders" ?

Hi.

 Actually it's possible to user ORDER as table name,  but you must enclose it in " ( double quotes ) :

 CREATE TABLE "ORDER" ( ord_no NUMBER ( 8 ) primary key,   order_desc VARCHAR2(20));

 But afterward you must use " everywhere and the table  name becames case sensitive.
 So it's too much trouble anyway.

 Be happy and use ORDERS as table name instead.

 Michael.

In article <7u2ggq$1tq$1_at_nnrp1.deja.com>,   dgallardo_at_my-deja.com wrote:
> A: invalid table name "order".
>
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 13 1999 - 15:50:31 CDT