| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-00933: SQL command not properly ended
res0nlrn wrote:
> delete <objecttype> <objectname> is the proper
>
> > delete telecomm.ias_records
> > *
> > ERROR at line 6:
> > ORA-00933: SQL command not properly ended
Aren't you confusing DELETE with DROP?
DROP <object_type> <object_name> as in
DROP TABLE mytable;
A delete is:
DELETE FROM <table_name>;
And usually with a WHERE clause to keep from dumping the entire contents of the table.
Daniel Morgan Received on Wed Sep 25 2002 - 15:01:57 CDT
 |
 |