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: Kumar, Sai (EXCHANGE:PERPK:3374) <saikumar_at_nortel.com>
Date: Wed, 14 Apr 1999 11:19:27 -0400
Message-ID: <3714B1FF.12F14A31@nortel.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

Moises,

To commit after each insert statement,
do the following :-
set autocommit on

Thanks
Sai Received on Wed Apr 14 1999 - 10:19:27 CDT

Original text of this message

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