Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: deleting large number of records from table...

Re: deleting large number of records from table...

From: Tlcbus <tlcbus_at_aol.com>
Date: 1997/11/11
Message-ID: <19971111014001.UAA25691@ladder02.news.aol.com>#1/1

you can write a pl/sql block - open up a cursor and loop thru and count the  number of records(2000 records) then commit and all over again until  %notfound. Ted Chyn Received on Tue Nov 11 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US