Re: ** Want a new DELETE command **

From: Steve Corbett <stevec_at_fcs.wa.gov.au>
Date: 1997/05/20
Message-ID: <3381584A.1B32@fcs.wa.gov.au>#1/1

Doug Anderson wrote:
> Wouldn't it be nice if you could do something like the following...
> DELETE FROM table
> WHERE ...
> COMMIT EVERY n ROWS;

you can do this by building a pl/sql loop, eg:

begin
loop

        delete table_name
         where rownum < 1000;
        exit when sql%notfound;
        commit;

end loop;
end;

stevec. Received on Tue May 20 1997 - 00:00:00 CDT