Auto Commit

[Ralph]

I want to know the commands in Oracle that would cause an automatic commit. Can anyone provide me the list of these commands.

[gpraveen_mca]

SET AUTOCOMMIT ON - this command will set automatic commit on.
SET AUTOCOMMIT OFF - this command will set automatic commit off.
SHOW ALL - this command is used to view the commit status.

[Ralph]

Friend the option that you said are for setting he autocommit on and off. BUt my doubt is what are all the commands in oracle that would get commited automatically.

[oracleobsessed]

all DDL statements in oracle ends in a auto commit, examples can be using CREATE, ALTER,DROP,RENAME,TRUNCATE....

[Ralph]

Ohh that's nice to know. Will the commands Select and Insert cause automatic commit.

[oracleobsessed]

No select and Insert are DML statements and wont provide an autocommit, 'select' infact dont have to be comitted as u are just viewing data that has already been written to datafiles, insert may be lost if hav an abnormal shutdown occur.
But for DDL statements that i mentioned before u will hav ur changes auto commited as soon as u perform them and these doesnt require a clean shutdown.

[nagivijay]

DML statements doen't autocommit the transaction until you do so, remeber when your performing commit or rollback statements thats only for your log session. when your perform DDL statements and DCL statements they usually autocommit the session, remember if you had performed a DDL,DCL statement, after an DML it will auto commits the entire session (so be careful with DDL, DCL).