from is optional
"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
news:3D921628.3E18AA4C_at_exesolutions.com...
> 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:07:05 CDT
