Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-00903

Re: ORA-00903

From: joel garry <joel-garry_at_home.com>
Date: Wed, 01 Aug 2007 13:41:25 -0700
Message-ID: <1186000885.641350.61260@z24g2000prh.googlegroups.com>


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
Received on Wed Aug 01 2007 - 15:41:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US