-
I really dont understand this???
I am logged in as user "PRODUCTION", I look in the schema "PRODUCTION" for my "table triangle_lvl1"
I see it no prob.
I run from a sql prompt "select * from triangle_lvl1;"
it returns the data
I run "delete * from triangle_lvl1;" and I get an ora-00903: invalid table name????
I then thru SQLNavigator( still logged in as "PRODUCTION") did a right click on the table and was able to truncate the table. I went back to the sql prompt and did a "select * from triangle_lvl1;" it returns O rows as i would expect. I then run "delete * from triangle_lvl1;" and I once again get an ora-00903: invalid table name????
I even tried to grant delete to myself for the table but your not allowed to do that( well at least I get that).
Thanks in advance,
SMD
-
I think the syntax is:
delete from tablename;
(no "*")
-
Yes, that looks like your problem:
SQL> truncate table test;
Table truncated.
SQL> delete from test;
0 rows deleted.
SQL> delete * from test;
delete * from test
*
ERROR at line 1:
ORA-00903: invalid table name
Jeff Hunter
-
Dooooh!
thanks tons
sometimes its ez to overlook the ez one, lol
thanks again
-
the "from" word is optional also.
delete test;
deletes all the rows in test.
Oracle DBA and Developer
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|