SQL question

[Dave Hull]

On Fri, 8 Aug 2003, Brian Densmore wrote:

> 2) is there anyway to have a single delete query statement
> do periodic commits (as really dangerous as it is)?

Depends on the DBMS, I suppose. I know in Oracle one can "set autocommit on" 
in certain client software and each delete statement will be committed as soon 
as it is completed. I have resorted to this when deleting all rows from all 
tables in Oracle.

-- 
Dave Hull
http://insipid.com

Well, how well can actual revolutionaries be loved if they don't do
the numbers?
-- Steve Nordquist, Amor Milquetoast, Lebens8, 02/08/00