No delete from is the correct syntax ( I mistype that nearly every time
-( ).
Niall
Pam Lantzy <plantzy_at_uamail.albany.edu> wrote in message
news:37DF89A8.3080688_at_uamail.albany.edu...
> I believe the problem is his SQL DELETE statement
>
> try: delete * from event;
>
>
> KM wrote:
>
> > Have you tried taking out the semicolons (but leave the slashes between
> > statements)?
> >
> > <svedloff_at_ix.netcom.com> wrote in message
> > news:37de881f.7287899_at_nntp.ix.netcom.com...
> > > I am using Personal Oracle 8, and I am ahvign probelm with having
> > > more than 1 SQL statement in SqlPlus.
> > >
> > > I have a file, called mydata.sql, that looks like this:
> > >
> > > delete from Event;
> > > insert into Event (EventID, EventType) values(1, 'test');
> > > insert into Event (EventID, EventType) values(2, 'test');
> > >
> > > When i run it in SqlPlus, I get the following:
> > >
> > > SQL>
> > > SQL>
> > > 1 delete from Event;
> > > 2 insert into Event (EventID, EventType) values(1, 'test');
> > > 3* insert into Event (EventID, EventType) values(2, 'test');
> > > 4 /
> > > delete from Event;
> > > *
> > > ERROR at line 1:
> > > ORA-00911: invalid character
> > >
> > >
> > > SQL>
> > >
> > > The '/' on line 4 I had to enter myself. The asterisk showed up
> > > directly under the semicolon on the line above it.
> > >
> > > I also tried putting '/' after each line, and I got the same problem:
> > >
> > > delete from Event;
> > > /
> > > insert into Event (EventID, EventType) values(1, 'test');
> > > /
> > > insert into Event (EventID, EventType) values(2, 'test');
> > > /
> > >
>
Received on Wed Sep 22 1999 - 09:48:02 CDT
