Re: TRUNCATE in PL/SQL

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;
Received on Mon Apr 10 2000 - 00:00:00 CDT