Setting autocommit on in Oracle doesn't mean you have a commit as soon as
each row that returns from the subquery is deleted (which is what I think he
wants), but rather, you have a commit as soon as every row that returns from
the subquery is deleted.

----- Original Message -----
From: "Dave Hull" <dphull@insipid.com>
Cc: "KCLUG (E-mail)" <kclug@kclug.org>
Sent: Saturday, August 09, 2003 12:55 AM
Subject: Re: SQL question

> 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
>
>
>