OraFAQ Forum: Application Express, ORDS & MOD_PLSQL

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » ORA-00903: invalid table name

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00903: invalid table name [message #140699]

Wed, 05 October 2005 05:02

rachit.shah
Messages: 5
Registered: September 2005
Location: Hyderabad

Junior Member

Currently I am using htmldb.oracle.com but surprisingly I am able to create tables and show its records but i am not able to delete the content or drop the tables;

I have schema named RACHIT and I have created table named rachit.

When I select * from tab; It doesn't show rachit table

I have created another table anusha and resham. It shows these tables when I select * from tab;

Even I can insert the records in all the three tables and see the content of table but I cant delete the records nor I can drop the tables

on

delete * from anusha;

It says

ORA-00903: invalid table name

Report message to a moderator

Re: ORA-00903: invalid table name [message #140794 is a reply to message #140699]

Wed, 05 October 2005 11:43

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

You'll have better luck with htmldb questions like this on the OTN Oracle HTMLDB discussion forum, which is quite active.

Report message to a moderator

Re: ORA-00903: invalid table name [message #140956 is a reply to message #140699]

Thu, 06 October 2005 07:12

rachit.shah
Messages: 5
Registered: September 2005
Location: Hyderabad

Junior Member

Next reference says sql supports both syntax (i.e delete * from table_name and delete from tablename)

http://www.w3schools.com/sql/sql_delete.asp

I think oracle does not allow

delete * from table_name

Report message to a moderator

Re: ORA-00903: invalid table name [message #141182 is a reply to message #140699]

Fri, 07 October 2005 07:28

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You syntax is wrong.

scott@9i > delete * from emp;
delete * from emp
       *
ERROR at line 1:
ORA-00903: invalid table name


scott@9i > delete from emp;

14 rows deleted.

Report message to a moderator

Previous Topic:	Need help in creating a tree page in htmldb
Next Topic:	HTMLDB Calendar Day Link

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 14:20:14 CST 2025