Re: TRUNCATE in PL/SQL

Yes, I cought that. Thank you.

I appreciate everyone's help on this!

jim

On Mon, 10 Apr 2000, Steffen G ck wrote:

> Steffen G ck <stevie-g_at_gmx.de> schrieb in im Newsbeitrag:
> 8cl94g$k0t$1_at_news03.btx.dtag.de...
>
> sorry, there must be a commit of course!
>
> > perhaps this is the best solution:
> >
> > loop
> > delete from table test
> > where rownum < 1000;
> >

   COMMIT;
> > if sql%rowcount = 0
> > then exit;
> > end if;
> >
> > end loop;
>
>
>
>
>

Jim Bromhal
bromhal_at_world-net.net
www.world-net.net/home/bromhal Received on Tue Apr 11 2000 - 00:00:00 CDT