Oracle - Is (DDL) Data Manipulation Language statements Autocommit?

GeekInterview.com > Tech FAQs > Oracle

Go To First | Previous Question | Next Question

Oracle | Question 2 of 244

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

Total Answers and Comments: 4

Last Update: November 01, 2007 Asked by: srinivasan

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

February 16, 2006 23:17:54

prasadmeduri

Member Since: February 2006 Contribution: 12

RE: Is (DDL) Data Manipulation Language statements Aut...

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.

Is this answer useful? Yes | No

July 02, 2007 07:40:35

knarender

Member Since: June 2007 Contribution: 11

RE: Is (DDL) Data Manipulation Language statements Aut...

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.

Is this answer useful? Yes | No

August 20, 2007 10:04:00

Arindam Ghsoh

RE: Is (DDL) Data Manipulation Language statements Aut...

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

Is this answer useful? Yes | No

November 01, 2007 07:16:34

Hema

RE: Is (DDL) Data Manipulation Language statements Aut...

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.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank