Re: ORA-00903

On Aug 1, 1:20 pm, Sashi <small..._at_gmail.com> wrote:
> How come the server throws out a message which seems to send me off on
> a tangent?
> A syntax error, I would imagine, should be pretty simple to catch for
> even a basic parser.

SQL> create table "*" (C1 VARCHAR2(10));

Table created.

SQL> insert into "*" values ('AAAD');

1 row created.

SQL> delete *;
delete *

       *
ERROR at line 1:
ORA-00903: invalid table name

SQL> delete "*";

1 row deleted.

SQL> drop table "*";

Table dropped.

SQL> Would you rather it deleted or dropped all tables? :-O

(Any prize for "worst name for table" Dan? :-)

jg

--
@home.com is bogus.
"How do you cut online crime, tackle child pornography, halt crippling
viruses and get rid of spam?" http://www.guardian.co.uk/technology/2007/aug/01/news.internet