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

Home -> Community -> Usenet -> c.d.o.server -> Re: how to auto commit in oracle?

Re: how to auto commit in oracle?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 7 May 2003 02:25:28 -0700
Message-ID: <a20d28ee.0305070125.67d03526@posting.google.com>


"Xie Haifeng" <xiehaifeng_at_hotmail.com> wrote in message news:<b9aall$h2aam$1_at_ID-179281.news.dfncis.de>...
> Hi all,
> I'm using oracle 8.1.7 on linux. And when I have executed a
> insert/delete/update statement in sqlplus, I must manually execute "commit"
> command otherwise the other people can't see the modified data in their db
> connection. Does it possible to change some configs and make oracle server
> to commit transaction automatically?
> Thanks a lot.
>
> xie.

set autocommit on in sql*plus.
This is however considered *BAD* practice, as you won't get any proper transactions.
I would recommend seriously you to try to *LEARN* Oracle, instead of porting bad habits of other products to Oracle.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Wed May 07 2003 - 04:25:28 CDT

Original text of this message

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