Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » ORA-00903: invalid table name
ORA-00903: invalid table name [message #140699] Wed, 05 October 2005 05:02 Go to next message
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
Re: ORA-00903: invalid table name [message #140794 is a reply to message #140699] Wed, 05 October 2005 11:43 Go to previous messageGo to next message
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.
Re: ORA-00903: invalid table name [message #140956 is a reply to message #140699] Thu, 06 October 2005 07:12 Go to previous messageGo to next message
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

Re: ORA-00903: invalid table name [message #141182 is a reply to message #140699] Fri, 07 October 2005 07:28 Go to previous message
Mahesh Rajendran
Messages: 10707
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.
Previous Topic: Need help in creating a tree page in htmldb
Next Topic: HTMLDB Calendar Day Link
Goto Forum:
  


Current Time: Thu Mar 28 05:25:44 CDT 2024