Home » RDBMS Server » Server Administration » cannot delete*from
cannot delete*from [message #372348] Sun, 04 February 2001 16:27 Go to next message
timmy
Messages: 10
Registered: February 2001
Junior Member
learning some basic sql....created a table...i can select, insert into the created table but when i go to delete something i keep getting an error that it is a invalid or missing table(can't find table) would have to do with privilege or locks or? thanks

Report message to a moderator

Re: cannot delete*from [message #372375 is a reply to message #372348] Tue, 06 February 2001 07:46 Go to previous message
hong yang
Messages: 1
Registered: February 2001
Junior Member
the command for deleting is:

delete from table_test;

Dont use the asterisk.

Report message to a moderator

Previous Topic: How convert varchar2 to RAW in PL/SQL
Next Topic: sql basic question (the nop problem)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 01:07:13 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.