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

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Command?

Re: SQL Command?

From: Patrick Suppes <psuppes_at_lucent.com>
Date: Mon, 19 Apr 1999 13:23:53 -0600
Message-ID: <371B82C9.A8C66FA7@lucent.com>


The short answer is NO, you cannot commit after every insert in a sql statement. Autocommit occurs between statements, as does the commits described by Mr. Fredericks.

Patrick Suppes
psuppes_at_lucent.com

NetScans wrote:

> Hope someone can help me. Is there any way to commit after every insert
> and not at the end of the sql statement? I know in SQL+ there is "set
> auto off" is there a command in SQL?
>
> Thanks,
> Moises
Received on Mon Apr 19 1999 - 14:23:53 CDT

Original text of this message

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