Re: how to auto commit in oracle?

"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