or even just delete Tablename.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Dmitry E. Loginov" <dmitry_loginov_at_mtu.ru> wrote in message
news:9vgi5e$1j0i$1_at_gavrilo.mtu.ru...
> There is a extra '*' sign in your statement.
> It should be
> delete from TABLENAME;
>
> "Mike" <Mike_at_here.com> wrote in message
> news:3c1b9fad$1_4_at_corp.newsgroups.com...
> > Thanks for the info Jim.
> >
> > I had tried:
> > DELETE * FROM TABLENAME;
> > Which gives an error message.
> >
> > I'll truncate and see if it works. No problem on rollback as the data is
> > only temporary.
> >
> > Mike
> >
> > "Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message
> > news:xFKS7.1613$KY.76301_at_rwcrnsc54...
> > > can't you just do
> > > delete from table tableName
> > > or
> > > truncate table tableName;
> > > (caution, while truncate is faster you cannot rollback the transaction
> and
> > > it issues its own commit)
> > > Jim
> > > "Mike" <Mike_at_here.com> wrote in message
> > > news:3c1b59d2_3_at_corp.newsgroups.com...
> > > > Anyone know of a way to delete all records in a table using rdo in
vb
> ?
> > > >
> > > > Currently dropping table and creating it again. Is there a better
way
> ?
> > > >
> > > > Sample Code:
> > > > Dim rdoOracle As New rdoConnection
> > > >
> > > > Dim myOracle As rdoResultset 'For Oracle tables.
> > > >
> > > > 'DROP TABLE.
> > > > On Error Resume Next
> > > > SQL = " DROP TABLE MY_ORACLE_TABLE "
> > > > Set myOracle = rdoOracle.OpenResultset(SQL, , , rdExecDirect)
> > > >
> > > > 'CREATE TABLE ROUTINE FOLLOWS...
> > > >
> > > > Thanks for any help.
> > > >
> > > > Mike
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> > > > http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> > > > -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
> > >
> > >
> >
> >
> >
> >
> > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> > http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> > -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
> >
>
>
Received on Mon Dec 17 2001 - 03:08:50 CST
