Re: TRUNCATE in PL/SQL

perhaps this is the best solution:

loop
  delete from table test

     where rownum < 1000;

  if sql%rowcount = 0
    then exit;
  end if;

end loop;

this way the database has not to drop and allocate extents during 'drop table' or 'truncate table' and overhead and fragmentation would be avoided.

Steffen Göck
www.goeck.com Received on Fri Apr 07 2000 - 00:00:00 CDT