How to set Autocommit OFF

Hi All,
plz tell me how to set autocommit off. I guess by default auto commit is ON. I want to do the same for at database level. Any parameter for that??
Thanks in advance...
Sandy

AFAIK it is a SQL*Plus command and there is no such parameter that can be set in init.ora file.

Sanjay

is there any way to set autocommit off??

From Sqlplus

Code:

---

set autocommit off;

---

Sanjay

Hi Sanjay,
Thanks fo rthe fast reply...but my question was that can we do it at database level??
Moreover even I set Autocommit off at the session level and I exit the session without commit, but still I can see those values which I deleted but did not commit. Any solution??

Closing a user session does an explicit commit even if you set autocommit off. Similarly any DDL will also do an explicit commit. I don't think you can set autocommit off at database level.

HTH
Sanjay

Quote:

---

Originally posted by SANJAY_G
Closing a user session does an explicit commit even if you set autocommit off. Similarly any DDL will also do an explicit commit.
HTH
Sanjay

---

Then what is use of SET AUTOCOMMIT OFF. In what condition it works??

When you set autocommit on. The DMLs are commited immedialy after the statement finishes. But in case of autocommit off it is not commited unless you issue commit or exit from sqlplus.

While exiting from Pro*C or JDBC you need to explicitly commit the transaction otherwise it will be rolled back.

Sanjay

Thanks Sanjay...it was a useful information...
Sandy