Re: Q: invalid table name "orders" ?

Order is a 'reserved word' and cannot be used as a table name, orders is not..

A reserved word is one that Oracle uses ( like select * from emp ORDER by name ) in other than a table name context, and to use it could cause parsing confusion and errors..

HTH,
John Greco

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.

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Wed Oct 13 1999 - 13:41:13 CDT