Is (DDL) Data Manipulation Language statements Autocommit?

No. Only the DDL(Data Definition Language )statements like create,alter,drop,truncate are auto commit.
But the DML statements are should be saved by giving the commit statement after execute the query

Interview Candidate
Nov 7th, 2005
4
36635

Basics

Answer

Showing Answers 1 - 4 of 4 Answers

prasadmeduri
Profile Answers by prasadmeduri

Feb 16th, 2006

Every DDL command has auto commit.
ex.create,drop,alter,grant,revoke etc.
But DML command does not have auto commit.
we have option to rollback the changes after any DML query execution.
and also explicitly we can commit the changes.

knarender
Profile Answers by knarender Questions by knarender

Jul 2nd, 2007

Only DDL statements like create,Alter,Drop,Rename,Truncate are Auto commit,
where as for DML statements like Insert,Update,Delete we should give externally commit by user, after the execution of Sql statement.

Arindam Ghsoh

Aug 20th, 2007

DDL and DML are different.
DDL is data definition language and it has autocommit
But in DML there is no auto commit.

Hema

Nov 1st, 2007

DDL is Data Definition Language. DDL commands work on the table directly or on the table structure. By default it has auto commit.

DML is Data Manipulation language that affects the data present in the table. Any addition or modification of data has to be saved by the Commit command.