Rampraas

 Profile Answers by Rampraas Questions by Rampraas

• Mar 28th, 2006

 

Not Possible.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

 

For DDL commands you can set auto commit off.

auto commit off: refers to setting the option incase your session got some problem before completing the query, then oracle instace will wait for time set by dba and look for setting ( auto commit on/off) accordingly it will perform the action.

lovely sethii

 Profile Answers by lovely sethii 

• Jun 17th, 2008

 

by using set autocommit on we can do it

vishakha_jain81

 Profile Answers by vishakha_jain81 

• Aug 12th, 2008

 

For DDL commands, We cannot do autocommit off. It is modify structure of database object such as table, view and these commands have automatically commit.

Set autocommit on/off is used for DML.